The other thing worse than pagination is broken pagination. The initial query of all rows might be slow, but once I have a snapshot speed is not the issue. I r

The other thing worse than pagination is broken pagination. The initial query of all rows might be slow, but once I have a snapshot speed is not the issue. I regularly do ctrl+a ctrl+c alt+tab to Excel and ctrl+j to run a program that gives me the result I am looking for. Where I have control over the back-end, I like to provide static dated snapshots of queries. I can be stingy but I would look at: Time to run the query vs. Value of having all the data.