3 ms·
In our non-web app we do this. We have "special" grids for this which wraps our query as a subquery, does a count() so it can accurately draw the scrollbar, the
by magicalhippo 5y ago
In our non-web app we do this. We have "special" grids for this which wraps our query as a subquery, does a count() so it can accurately draw the scrollbar, then uses limits to pull only the visible rows from the database.
When the user add filters on columns or sets sort order it's added in the where or order by clause respectively of the outer query.
This way we can easily show 100k+ rows (like, all their invoices or orders), the user can scroll and filter to their delight etc, all super-responsive.
Surely it shouldn't be much harder to support on the web if one wanted?