MySQL Paging slow accelerator solution MySQL paging optimized MySQL paging solution LIMIT optimization

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