… EXPLAIN is a really cool idea. For most of my paginations, I created a different approach (and even use different approaches…
Comment: MySQL random freezes could be the query cache
March 20, 2009 By 23 Comments
… or freeing items, not responding to kills): gdb -p set pagination off thread apply all bt and look for lots of…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
February 6, 2009 By 57 Comments
…. After some analysis I found the following: I’m retrieving paginated results from the quite large tables (WHERE column like pattern…
Comment: ORDER BY ... LIMIT Performance Optimization
December 29, 2008 By 100 Comments
… (4.58 sec) So even if I use indexes, the paginationing on huge table is very slow 
Any idea why? My…
Comment: A common problem when optimizing COUNT()
November 29, 2008 By 19 Comments
… the number returned isn’t accurate but works great for pagination. When was the last time a user went to page…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… of the same components. Tagging, friends, queues, click tracking, search, paginated displays — we’ve seen these and dozens of other common…
Comment: ORDER BY ... LIMIT Performance Optimization
October 24, 2008 By 100 Comments
…. Typically we do a count first to create all the pagination stuff. Current page, total pages, etc. Example of it in…
Comment: Four ways to optimize paginated displays
September 25, 2008 By 27 Comments
… they are more relevant to showing search results than other paginated display settings. Google may seem like a magic keyword but…
Comment: ORDER BY ... LIMIT Performance Optimization
April 23, 2008 By 100 Comments
[...] have just been reading this … ORDER BY … LIMIT Performance Optimization. Pagination is used on just about every site I work on – that article is great on speeding up [...]
Comment: Indexes in MySQL
June 2, 2006 By 29 Comments
Dear Pradeep, Try to select restricted data from the table. Because you can not show all 4 lacs of records at a time on the page, possibly use LIMIT or do pagination to your page. Also while selecting the data avoid using LIKE operator, search by = operator instead. Thanks, Balaji
