英文文档在这里:http://explainextended.com/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/
再补充一个Yahoo 的mysql pagination方案,对于分页巨多的大数据量,性能比较好:
http://www.percona.com/files/presentations/ppc2009/PPC2009_mysql_pagination.pdf
英文文档在这里:http://explainextended.com/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/