|
 |
asp_databases thread: work with recordset or load data into scripting.dictionary?
Message #1 by "cb" <wrox@e...> on Tue, 30 Oct 2001 17:13:54
|
|
Here is a question that seems not to be answered in any of my fat books:
If one has a read-only recordset, and a certain amount of iteration is
necessary to arrange the data before presenting it to a user, is it
faster/easier on the machine to:
-- create a static cursor and iterate over it as needed, or
-- create a forward-only cursor, dump the data into a scripting.dictionary
object, close the recordset, and iterate over the dictionary?
Message #2 by David Cameron <dcameron@i...> on Wed, 31 Oct 2001 09:59:52 +1100
|
|
GetRows.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: cb [mailto:wrox@e...]
Sent: Wednesday, 31 October 2001 3:14 AM
To: ASP Databases
Subject: [asp_databases] work with recordset or load data into
scripting.dictionary?
Here is a question that seems not to be answered in any of my fat books:
If one has a read-only recordset, and a certain amount of iteration is
necessary to arrange the data before presenting it to a user, is it
faster/easier on the machine to:
-- create a static cursor and iterate over it as needed, or
-- create a forward-only cursor, dump the data into a scripting.dictionary
object, close the recordset, and iterate over the dictionary?
Message #3 by Kyle Burns <kburns@c...> on Wed, 31 Oct 2001 09:51:48 -0500
|
|
Excellent suggestion. People seem to forget about GetRows and GetString (I
myself remember GetString and forget GetRows).
=================================
Kyle M. Burns, MCSD, MCT
ECommerce Technology Manager
Centra Credit Union
kburns@c...
-----Original Message-----
From: David Cameron [mailto:dcameron@i...]
Sent: Tuesday, October 30, 2001 6:00 PM
To: ASP Databases
Subject: [asp_databases] RE: work with recordset or load data into
scripti ng.dictionary?
GetRows.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: cb [mailto:wrox@e...]
Sent: Wednesday, 31 October 2001 3:14 AM
To: ASP Databases
Subject: [asp_databases] work with recordset or load data into
scripting.dictionary?
Here is a question that seems not to be answered in any of my fat books:
If one has a read-only recordset, and a certain amount of iteration is
necessary to arrange the data before presenting it to a user, is it
faster/easier on the machine to:
-- create a static cursor and iterate over it as needed, or
-- create a forward-only cursor, dump the data into a scripting.dictionary
object, close the recordset, and iterate over the dictionary?
|
|
|
View Cart
