分页查询优化,在程序内存中计算出id的值,要比通过select id from 表 order by id 49173090,100,先找到id,再关联查询要快很多的,大概快出3-5倍
SELECT * from table_1
WHERE id>49173090 ORDER BY id limit 0,100;
分页查询优化,在程序内存中计算出id的值,要比通过select id from 表 order by id 49173090,100,先找到id,再关联查询要快很多的,大概快出3-5倍
SELECT * from table_1
WHERE id>49173090 ORDER BY id limit 0,100;