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

留言

熱門文章