How to limit the results displayed on a table for tables with more than 1M records
I have a table with 7 million records, the default pagination I have is 50 per page.
Every time I need to paginate, the loading of the page is slow (I have indexes on the table).
- Does anyone know what is the best approach for big tables ?
- Can I limit the results to 10K by default ?
Any suggestion is welcomed.
Every time I need to paginate, the loading of the page is slow (I have indexes on the table).
- Does anyone know what is the best approach for big tables ?
- Can I limit the results to 10K by default ?
Any suggestion is welcomed.
