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
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
張貼者: Beaktsao 於 清晨7:34
沒有留言:
張貼留言