|
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]
records.movenext
Loop
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.
records.movelast
lngRecCount=records.RecordCount
records.movefirst
For lngCounter=1 to lngRecCount
combo1.additem records![Full Name]
records.movenext
Next lngCounter
You should
see about a 33% speed increase.
|
