2018年8月1日 星期三

Mysql select tip for large tables

Assume id is the primary key

select * from my_table where id >= 123456789 limit 30

is much faster than

select * from my_table limit 123456789, 30

沒有留言: