borderAndreaVB free resources for Visual Basic developersborder
AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincani
:: Faster your recordset searching

Author  

Fredrick Phua

Language  

VB5, VB6

Operating Systems  

Windows 95, 98, NT, Me and 2k
Tip
'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]
   record.MoveNext
Loop

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

Record.MoveLast
intCount=Record.RecordCount
Record.MoveFirst

For i=1 To intCount
  [search criteria]
  Records.MoveNext
Next i

'It can improve arround 40% faster. Try it!! 
:: Navigation

Home

Database Management

Previous Tip

Next Tip

:: Search this site
Google
:: Related Topics
icon 29-07-2005 Re: insert into MSAccess using recordset in VB by yronium
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincaniborder