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
select * from my_table where id >= 123456789 limit 30
is much faster than
select * from my_table limit 123456789, 30
留言