Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Method in ADO Recordset Slower

Status
Not open for further replies.
menumix

menumix

Programmer
Sep 17, 2002
1
IN
Hi,

I am using ADO Recordset in VB

My Problem is that whenever is am using Open Method like

Myrs.open "Select * from Ledger",,adopendynamic,adlockoptimistic

it is opening slowly when there are more records in Ledger table and it is faster when there are less records.

e.g
if there are 2500 records it takes 1.4 seconds
if there are 50 records it takes .14 seconds

It there are any solution to this pls kindly let me notified.

 
Status
Not open for further replies.

Similar threads

panosdk
  • Locked
  • Question
How to display context menu strip in a dhtml edit control vb.net
Replies
0
Views
397
panosdk
panosdk
gbrenkman
  • Locked
  • Question
ActiveX control in Word macro-enabled template in trusted location
Replies
0
Views
417
gbrenkman
gbrenkman
AsapComputerServices
  • Locked
  • Question
Gmail Active X Error with Internet Explorer
Replies
0
Views
396
AsapComputerServices
AsapComputerServices
asilverblatt
  • Locked
  • Question
lost in .OCX registration hell!!!
Replies
1
Views
449
asilverblatt
asilverblatt
TomCarnahan
  • Locked
  • Question
.MDB SS2K -- Disconnected ADO Recordsets for Forms and Processing?
Replies
1
Views
173
TomCarnahan
TomCarnahan

Part and Inventory Search

Sponsor

Back
Top