Array versus temporary recordset

G

Guest

Hi,

I am working on a project where I have the choice of
creating arrays of data or loading the data into temporary
recordsets. Does anybody have any stats on the relative
performance of each method of data storage and
manipulation? Using recordsets would probably make the
code a bit simpler, but if recordsets are going to take up
dramatically more resources, I'll crunch through the array
routines. Thanks for any thoughts!

Victor
 
C

Chris Nebinger

I don't have any stats, but for searching the recordset is
going to be faster, especially if using an index.


Chris Nebinger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordset in Memory 22
Dynamically referencing a recordset? 9
Using a temporary recordset as data source for a Word ail merge 0
How do I load data from a select query into an Array in VBA code? 5
A theoretical question: how best to manage perpetual recordset needs? 24
newbie needs examples of creating a recordset and inserting datausing it in Access 2007? 7
Copy or addnew from an array 1
ADO SQL Query, Possible to leave the Recordset open outside its Su 5

Top