A table with about 70K records is displayed on a site, showing 50 records per page. Pagination is done with limit offset,50 on the query, and the records can be ordered on different columns.

Son sayfaları (yani ofset yaklaşık 60.000) Browsing (yaklaşık 10x) ilk sayfalarını gezinirken daha sorgular daha yavaş yapar

Is this an issue of using the limit command? Are there other ways to get the same results?