recordsets vs arrays

[lenin]

Hi,
as far as programming styles and time considerations, are there any concrete numbers refering to the resource differences between using arrays and recordsets?

Is it more advantageous to use getrows when populating the array, if used?

Thanks

Lenin.

[monte96]

Depends.. if your doing it on an ASP page, yes, it is faster to use arrays. If your creating a readonly, forwardonly recordset to populate in a client server app, probably minor differences in speed.

Arrays are costly memory-wise, but do not require a type library to be loaded (although it(ADODB) is already loaded in this case)