The right way to do pagination

[tibberous]

You learn something new everyday:

 

http://www.arraystudio.com/as-workshop/mysql-get-total-number-of-rows-when-using-limit.html

 

Basically, rather than having to do a query twice, you can do it once, then do a second query to get the amount of total results. Not only is it better performance wise, but you don't need to have conditions in 2 places (and it avoids the bug where the queries are out of sync, and you'll have like 8 pages but only 2 real pages of results)

[xylex]

One query doesn't mean that it's faster than two.

 

http://www.mysqlperformanceblog.com/2007/08/28/to-sql_calc_found_rows-or-not-to-sql_calc_found_rows/