Search Tools Links Login

Faster Recordset Searching

Posted: 2019-09-13
By: FredrickPhua
Viewed: 194

Filed Under:

VB6 Databases, VB6 Code Cache

No attachments for this post

This really can make your database searching much faster if you implement this to a big database.

In normal search:

Do While Not record.EOF
   [search criteria]

To improve the search process, you can use this method:


For i=1 To intCount
   [search criteria]
Next i

It can improve arround 40% faster. Try it!!

Special Instructions

This code originally appeared on, and has been republished here with the permission of Andrea Tincani.

Comments on this post

No comments have been added for this post.

You must be logged in to make a comment.