What is the paging Method for large data volumes? Low LIMIT efficiency

What is the paging Method for large data volumes? What is the paging Method for a large amount of data with low LIMIT efficiency? Low LIMIT efficiency

Reply content:

What is the paging Method for large data volumes? Low LIMIT efficiency

$ SQL = "select * from user where id> {$ id} limit 10"; $ id indicates the maximum value of the previous page.

Cache the data. Maybe we should consider restructuring the database structure.

On the sphexample...

I don't know what database you are using. Does it support streaming )? If the data volume is large, it is suitable to use the streaming mode, so that data can be returned while being executed, instead of caching all data in the memory, thus reducing the pressure on the server.