Nick, several other replies raise questions about why you're doing what you're doing. This note is just to suggest that your belief that looping through a recordset and looping through a GetRows array are similarly inefficient is unfounded.
Under any circumstance in which we've tested it, looping through a GetRows array has been about 2-3 *TIMES* faster than looping through the recordset. We haven't bothered testing it lately - we now use GetRows for all read-only recordsets - but I recently saw a comparison which described a process taking about 25 seconds with a recordset, and about eight seconds with the recordset converted to a GetRows array. That's not an unusual result. HTH -----Original Message----- From: Nick Middleweek [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 9:07 PM To: ActiveServerPages Subject: One Select, 3 columns to fill 3 arrays? Hello, I can't think straight at the moment. Is it possible to do this... Perform ONE select field1, field2, field3 from ... operation on my MSSQL db. And then perform something similar to GetRows on the objRS so I end up copying the column data into the 3 arrays. Can I do this quickly? Or do I need to loop through the objRS with MoveNext - I was trying to avoid this and wanted a quick solution like GetRows. I know I can do GetRows, then loop through that 2D array but that's kind of slow as well isn't it? Any ideas? Thanks, Nick --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
