I am a big fan of .GetRows(), but is that the best approach here? If you are going to work with 3.5 million records, retrieving them all at the same time seems like a bad idea. You might be better off using traditional paging to retrieve subsets, and then if you like, to dump the subset into the .GetRows() function.
Best,
FtB
Main Topics
Browse All Topics





by: kevp75Posted on 2009-08-09 at 15:38:21ID: 25056284
I wonder if it would be too much of a performance hit to add the array to a recordset object or dictionary object and do it that way, or should I consider using the recordset object pre-population.
right now to get my array I am using parameterized queries, can I still use the recordset object in conjunction with the command object?