What is the paging method under the big data volume? Limit efficiency is not high

What is the paging method under the big data volume? Limit efficiency is not high

Reply content:

What is the paging method under the big data volume? Limit efficiency is not high

$sql = "select *from user where id>{$id} limit 10";$id为上一页最大的值

To cache the data, perhaps you should consider refactoring the database structure

The Sphinx ...

Do not know what database you use, whether to support streaming mode return data (streaming)? With large data volumes, it is appropriate to use the streaming mode so that data can be returned on one side of the data and not all of the data is in memory, easing the server pressure.

