Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "the method of Mysql paging optimization". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

When Internet companies have a large amount of data, slow page loading will directly lead to the decline of user experience, which determines the future of the product.

All efficient paging becomes particularly important.

Optimization principle

Minimize the number of records recorded in the scanning database.

Commonly used SQL

Select * from `Table name `order by id desc limit 0recover20

When the amount of data becomes larger, the SQL of the query

Select * from `Table name `order by id desc limit 100000Magi 20

Limit 100000Magne20 means scanning 100020 lines that meet the criteria.

Optimized SQL

/ / query the previous page of data

Select * from `Table name `where id 100020 order by id asc limit 20

Only 20 rows are scanned per query. Efficiency has improved!

This is the end of the content of "Mysql paging optimization method". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.