Level 75
When I had to do monthly reports I would dump the data to local and use Microsoft Access to handle the reporting. Prior to access I would use visual Foxpro. This stuff is so much more efficient in a local database.
Jan 24, 2018
1
Level 7
Handling 10s of thousands of rows
I have queries that I expect to take a long time - they are 10s of thousands (or 100s) of rows in the DB - how do you handle this ? Obviously pagination of results is step 1, but what if you need to retrieve those rows in order to output to a csv for a client who wants to manipulate them as a spreadsheet ?
Any thoughts as to how you resolved this?
Please or to participate in this conversation.