I'm developing a database application which communicates with an SQL Server using the ADO model. The recordsets I'm using have about 4000 records in them at any given time. I've noticed that when I use the FIND method to identify a specific record in a recordset it takes an usually long time to find that record (like 30 seconds).

Has anyone else experienced such slow find times? Is there any way to improve find efficiency?

Thanks in advance for the response,

Nahid Harjee