I am retrieving approximately 5000 records from a MySQL database.
I am doing this hundreds of times per second.
I need to process the data in my dataset VERY quickly.
- "look at each of the values"
- "do some calculations"
- "store a few bits of data elsewhere and then I'm done with the datatable"
I'm familiar with recordsets. I would use the Recordset.GetRows() command to throw the data into a multi-dimensional array.
Do I need to do something similar with recordsets?