Shulou(Shulou.com)05/31 Report--

This article introduces you how to optimize limit pagination, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Look at a case.

Click (here) to collapse or open

Mysql > select id from test06 order by id limit 2100000Bol 10

+-+

| | id |

+-+

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

| | 7037 |

+-+

In the above SQL, although the id column has an index, it locates from row 1 to 2000000 rows, and then scans out 10 rows, which is equivalent to a full table scan, which is obviously not efficient. After optimization, it is as follows:

Click (here) to collapse or open

Mysql > select id from test06 where id > = 2000000 order by id limit 10

Empty set (0.00 sec)

Obviously: the latter is written much faster than the former.

On how to optimize limit paging to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.