-
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
-
hi
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