A paginated display is one of the top optimization scenarios we see …’ worth of queries, and the two main queries for the paginated display consumed 2850 and 380 seconds, respectively. Why is it…. With that in mind, here are four suggestions for optimizing paginated displays that can give significantly better performance. On the first…
Comment: ORDER BY ... LIMIT Performance Optimization
October 26, 2008 By 100 Comments
…: “Typically we do a count first to create all the pagination stuff. Current page, total pages, etc.” – you have to create a counter for pagination information. Thank you for your solution, maybe I will try…
Comment: Four ways to optimize paginated displays
October 17, 2008 By 27 Comments
Baron, I had a slow query that involved pagination, so I investigated after reading your post on the matter. … not appear that the slowness was a result of the pagination at all (the query uses ORDER BY, GROUP BY, WHERE…
Comment: ORDER BY ... LIMIT Performance Optimization
October 14, 2008 By 100 Comments
One tweak that we do for large limit offsets on pagination is to first select columns that are part of the… orders of magnitude and allow our users to use large pagination. I assume it has something to do that the the…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
… MySQL very well. Solve some common application performance problems like paginating results and full-text search. Understand when to leverage MySQL…
Comment: Be productive with the MySQL command line
February 15, 2013 By 14 Comments
Awesome.. i was facing hard time with pagination. I did knot knew about pager command. Thanks for sharing.
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… for Unix/Linux. Using pager Most of the graphical tools paginate results, which is very handy. But this is not the…
Comment: ORDER BY ... LIMIT Performance Optimization
November 1, 2012 By 100 Comments
I made a simple test case comparing performance of the LIMIT approach vs the JOIN workaround. You can see the results here: http://devoluk.com/sql-pagination.html
Comment: COUNT(*) vs COUNT(col)
April 3, 2012 By 45 Comments
Hi Peter, For pagination stuff in high traffic websites having huge tables, we can …
Post: Preprocessing Data
August 8, 2011 By 3 Comments
…, then you can pre-generate that result. Examples could be pagination. On Request If there is no good way to preprocess…
