Mysql查询优化

三个语句，做了三次测试，差别还是比较明显。


Select * From locoy1 Where ID>=(
Select Max(ID) From (
 Select ID From locoy1  Order By ID limit 90001
) As tmp
) limit 29;

查询花费 0.0938 秒,0.0529 秒, 0.1050 秒

*****************************************************************************

Select * From locoy1  Where ID>=(
Select Max(ID) From (
 Select ID From locoy1 Order By ID limit 90000,1
) As tmp
) limit 29;

查询花费 0.0304 秒, 0.0201 秒, 0.0882秒

*****************************************************************************

Select * From locoy1   Where 1 limit 90001,29;

查询花费 0.1350 秒, 0.0677 秒, 0.2183 秒