AllAPI Network - The KPD-Team

Allapi Network

 API List

API Resources
 Tips & Tricks
 VB Tutorials
 Error Lookup
Misc Stuff
 VB examples
 VB Tools
 VB Links
 Top Downloads
This Site
 Search Engine
 Contact Form

Donate to

How to speed up database access

Here is a trick to loop through a recordset faster.  Often when looping through a recordset people will use the following code:

Do while not records.eof
    combo1.additem records![Full Name]

The problem is that everytime the database moves to the next record it must make a check to see if it has reached the end of the file. This slows the looping down a great deal. When moving or searching throuch a large record set this can make a major difference.  Here is a better way to do it.


For lngCounter=1 to lngRecCount
    combo1.additem records![Full Name]
Next lngCounter

You should see about a 33% speed increase.



Copyright © 1998-2007, The Team - Privacy statement
Did you find a bug on this page? Tell us!
This site is located at