Which is quicker?
- Thread starter tonyyeb
- Start date
Soldato
- Joined
- 18 Oct 2002
- Posts
- 16,104
- Location
- The land of milk & beans
I assume by ASP you mean both classic ASP and ADO, in which case a multi dimensional array is quicker and by a fair amount I would imagine.
The best thing to do when dealing with a big recordset (1k rows+) is to use the GetRows method to convert it to an array, then close the recordset.
More info here
The best thing to do when dealing with a big recordset (1k rows+) is to use the GetRows method to convert it to an array, then close the recordset.
More info here
Soldato
- Joined
- 18 Oct 2002
- Posts
- 16,104
- Location
- The land of milk & beans
The connection to the database would be required either way to fill the MD array.
However, the speed increase comes from looping through your data. Moving to the next row in a recordset involves database access and is therefore relatively slow. Looping through a disconnected recordset in an array stored in the memory will be like a greased whippet falling down a waterpark slide in comparison.
However, the speed increase comes from looping through your data. Moving to the next row in a recordset involves database access and is therefore relatively slow. Looping through a disconnected recordset in an array stored in the memory will be like a greased whippet falling down a waterpark slide in comparison.