Optimizing paging in MySQL
- 黄舟Original
- 2017-02-06 15:52:061336browse
An interview question, how to do paging when there is a large amount of data in the MySQL table. . . . At that time, I only knew that tables could be split when the amount of data was large, but I didn’t know what to do without splitting tables. . . . Alas, who asked the agent to only have a few pieces of data and a simple limit and offset to completely hold it down (face covering)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL Paging Performance Optimization GuideNext article：MySQL Paging Performance Optimization Guide