Pagination 10,000+ pages slow - Need faster alternative WITH sorting
I have a site with 10,000+ pages and it slows down when visiting page 9000 for instance. I know the LIMIT/OFFSET is the problem and that I could use MySQL to select rows that start by using an "ProductID" indicated in the pagination links.
However, I need to be able to sort by Price and TimeStamp, so the ProductID will be completely out of order.
In addition, I found a very similar site that works fast, has many sorting options and doesn't seem to use any kind of "starting point" in their pagination links: Example Site
If anyone has an idea on what this example site is doing with their MySQL, I would greatly appreciate your help in explaining.