MySQL Big Data paging query optimization

application scenarios;

When there is a table of data is very large, need to use to paging query, paging query after 100w query efficiency is very low;

Solution:

1, Business layer resolution: Only allow users to page 100 pages, 10 pages;

2. Use where ID > 5000000 limit 10; Data integrity is required, but you can consider the last ID that was checked each time you queried.

3. Deferred query: Select Table.id,table.name LEFT JOIN (SELECT ID from table limit 5000000,10) as tmp on table.id = tmp.id;id as index; 500w after the introduction of the ID, speed thief fast. Then through the index ID to query the corresponding each piece of data; Sudoku is fast; but it takes some time to query through the relational table in the mass data, but it is more than a few times higher than the previous one;

MySQL Big Data paging query optimization