Access ADO slow when recordset > 32,000 records

[dmassey]

Hi

I have a large recordset that I am looping through using ado and Jet 3.51. The table is in an access 97 database.
The code takes about 5 seconds to process the first 32000 records and then it slows to a crawl, looping through only about 10 records per second.

I am using a clientside cursor, maxrecords=200000, cachesize=1000, and the recordset is sorted.

It seems like ado is only sorting the first 32000 records for some reason.

Any Ideas?

Thanks, Derek

 

[phil009]

Try looking at thread700-866385 this may help you out.

Hope this helps,
Phil

 

[cmmrfrds]

Can you explain what you are doing with the recordset. That seems like a lot of records for a client to be reviewing, so I am guessing you are doing some kind of batch processing. There may be better ways to do the process.

 

[BNPMike]

Stick an index on it.