Urgent-ado sql speed

[OldDirtyBastard]

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

[veryjonny]

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

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

[gravyboy]

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.

[Gurbuly]

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