Urgent-ado sql speed

Hello All

I'm using ado to read an sql table that has 138000 records that I want to read into a datagrid/msflexgrid. The problem is when I run the program it takes approx 10mins to retrieve all the records.

Is there any way to approve the access of the records?

Any help appreciated

Thanks

Do u actually need all the records at the same time?

try using a query to reduce the numbers of records fetched.

Try doing an asynchronous fetch, the data 'appears' to be returned much quicker. This is 'cos the recordset returns the first bit of the data whilst retrieving the rest.

I have to apologise - I can't remember the code for this, so it's kind of an answer without answering.

and if you don't need to edit the data in the recordset avoid opening it dynamically..adOpenDynamic, if you can get away with it use adOpenForwardOnly,adLockReadOnly