level12 / webgrid

Other
12 stars 7 forks source link

Support different paging method #167

Open bchopson opened 1 year ago

bchopson commented 1 year ago

Perhaps one of the methods described here: https://use-the-index-luke.com/sql/partial-results

count on large tables in Postgres is slow: https://wiki.postgresql.org/wiki/Slow_Counting

The cost of count is incurred every time the grid is updated due to filtering/searching/sorting.