Select is much slower when selecting latest records

A table with about 70K records is displayed on a site, showing 50 records per page.Pagination is done with \[code\]limit offset,50\[/code\] on the query, and the records can be ordered on different columns.Browsing the latest pages (so the offset is around 60,000) makes the queries much slower than when browsing the first pages (about 10x)Is this an issue of using the \[code\]limit\[/code\] command?Are there other ways to get the same results?
 
Back
Top