Whether you are Innod engine limit paging slow or myisam engine limit paging slow , everyone select query paging This is generally the "data total 20,000, you need to query 3 fields":
SELECT ' id ', ' url ', ' content ' from ' product ' WHERE 1ORDER by ' id ' LIMIT 10000, 100
The execution speed is:
45.7Seconds
Haha, slow down the slag!
Author let again grand Recommendation
MYSQL LIMIT Paging Query accelerates the tool solution:
http://my.oschina.net/cart/
Select ' id ', ' url ', ' content ' from Productinner JOIN (select ' id ' from Productorder by ' id ' LIMIT 10000, +) as product2u SING (ID)
The execution speed is:
0
. theSeconds
We will not use the traditional paging method in the future, to use the latest paging optimization accelerator solution:
Select ' id ', ' url ', ' content ' from product INNER JOIN (SELECT ' ID ' from product ORDER by ' id ', ' LIMIT 0 ') as Product2 USING (ID)
Why is MySQL paging slow accelerator fast?
I just want to say 4 words: Overwrite index
MySQL Paging slow accelerator solution MySQL paging optimized MySQL paging solution LIMIT optimization