[AccessD] Using ADO to open a non-caching recordset

Gustav Brock Gustav at cactus.dk
Sat May 7 10:14:00 CDT 2005


Hi Josh

Forward Only will not help you as that is read-only.

However, you can modify your SQL to retrieve one record only:

SELECT TOP 1 * FROM tblTable ...

If you were able to open the table directly, you can open it as append
only, retrieving zero records.

/gustav

>>> darsant at gmail.com 05/07 2:55 pm >>>
I've come across a problem. I'm trying to access a recordset (which is
basically defined as a SELECT Query) for the sole intent of adding new
records for it. However, the recordset needs to be opened and closed
multiple times during the course of the program.

As it's running through adding records, as the table gets larger
(>300,000 records) the time it takes to reopen the recordset slows the
program down is horrible.

Is it possible to open a recordset without it pulling a cache of the
current records? With the execute command in ADO I know you can tell
it to not return a recordset, but not sure if there's a "Add only"
recordset option. Forward-Only looks like it might help, but I can't
seem to see a performance increase using this type only.

I'm still fairly new to using ADO but any suggestions are welcome!

Thanks,
Josh McFarlane




More information about the AccessD mailing list