Find.First (DOA) or Find (ADO) question

is Find.First or Find a sequential or direct search?

Hi, FindFirst does a sequential search starting from the beginning of the recordset, ofcourse u can set it to start at the end of the recordset and come in the reverse order. Anyway Find does a Sequential Search.

But what if i have a table with 250.000 records, the "find" will be very slow? How can do a direct search??

TIA

[Edited by JuanCarlos60 on 11-04-2000 at 07:08 PM]

Hi, i know that "seek" method works faster than the "find" method and i am sorry i never used it before. But the requirement for "Seek" is that the table u want to use should be indexed and sorted.
---I think "Seek" uses one of those popular searching mechanisms where in it compares the starting and ending indexes with the index u want to find, divide the table into two halves, take the half in which ur index might be in and then again perform the comparision blah blah and at a certain point of time it has to do the sequential search.---.
---Yes, find always starts at the beginning of the recordset or the ending of the recordset. You will definitely have to work around the problem of populating ur recordset with all the 250,000 records from the table. Do you always need to have all the records ?---

Please try using "seek" and if u can successfully then u will find it faster than "Find". But, remember one thing there is always a workaround for every problem.

All the best...with regards...vijay