What is the fastest recordset type?

[Tekime]

Reading through chapter six of Microsoft Access 2000: Building Applications with Forms and Reports it explains that the forward-only type Recordset object is usually the fastest method. I assume that a table-type recordset would be somewhat faster, but like most of us I am using linked tables for 95% of my records so it isn't an option most of the time.

When it comes to simple, read only queries, and I only want to retrieve one row of a record, what is the best bet? Would I be better off using a snapshot or forward-only type?

 

[dcx693]

The forward only type will be faster than a snapshot. You can go through a snapshot in both directions. It would also be faster than a table-type, of course, depending on what you wanted to do. If you just want to pick out one record as you mentioned, I'm guessing the forward only would still be faster unless you had a particularly large Indexed recordset that you needed to do a .Seek on.

BTW, if your linked tables are in mdb files, you can use DAO to open those linked tables directly, if you need to.

 

[Tekime]

Hi dcx693, I aprreciate the clarification. Also I apologize for not getting back sooner, I'm far too busy as always

In your final comment, do you mean I can open a linked table as a table-type recordset if they are in .MDB?

Thanks!

 

[dcx693]

In your final comment, do you mean I can open a linked table as a table-type recordset if they are in .MDB?

Yes, it's true. The technique is described here: After Splitting DB error - Object isn't supported .

 

[Tekime]

Very cool, thanks for the info.

 

[Tekime]

Pat, I'm using forward-only now when I'm just retreiving one or a few records.