Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 4th, 2003, 10:04 PM
Authorized User
 
Join Date: Jun 2003
Location: , FL, USA.
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default Performance Question

I have been looking for an answer to the following question and so far my reference material has been unable to help me. I hope someone here has an answer...

In a multi-user environment with a VB front end and an Access 2000 back end which method provides a faster result and less network traffic

rst.Open strSQL, cxn, adOpenForwardOnly, adLockReadOnly, adCmdText

or

Set rst = cxn.Execute(strSQL, , adCmdText)

??????

Thanx for your ideas.

Kenny Alligood
__________________
Kenny Alligood
  #2 (permalink)  
Old August 10th, 2003, 11:50 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Given that you are explicitly opening the recordset as forward only - read only (i.e. firehose), I doubt there is any meaningful difference in the two methods, as the recordset returned by the connection's execute method is always a firehose cursor - so the two recordsets are the same.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com
  #3 (permalink)  
Old August 11th, 2003, 08:54 AM
Authorized User
 
Join Date: Jun 2003
Location: , FL, USA.
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanx for the input Jeff.

Kenny Alligood


Similar Threads
Thread Thread Starter Forum Replies Last Post
Question on scalability and performance ThanhD BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 4 April 17th, 2007 02:13 PM
indexing performance question BinFrog SQL Server 2000 1 February 23rd, 2005 11:47 PM
query performance question kBusby Oracle 3 February 14th, 2005 04:42 PM
Ado.net performance question (SQL server vs OleDB spamp ADO.NET 1 August 2nd, 2004 10:37 AM
performance question.. gbianchi Pro VB 6 6 October 8th, 2003 11:21 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.