I am using VB 6 and ADO. I run a query like "SELECT * FROM Products" which returns a recordset of 86,000 records. Watching the memory on my machine, it uses up 500 Mb of RAM. Does anyone know if it is possible to run this same query using ADO, but to have it only load for example 1000 records into memory at a time and then would there be a method to call to retrieve into memory the next batch of 1000 records?
I have found the .nextrecordset method, but that appears to only work if you pass multiple queries to the ADO recordset and what I need is to pass only one query, but return the results in chunks of 1000 records at a time.
I have done my best to search the web looking for a solution, but I have not found one. I know it must be possible.