是一条SQL查询 十万条记录快 还是10条SQL查询同时各查 一万 条记录快呢1, select * from person where iPersonID between 1 and 1000002, select * from person where iPersonID between 1 and 10000 select * from person where iPersonID between 10001 and 20000 select * from person where iPersonID between 20001 and 30000 select * from person where iPersonID between 30001 and 40000 ……我也不晓得 ,,。。
还是10条SQL查询同时各查 一万 条记录快呢1,
select * from person where iPersonID between 1 and 1000002,
select * from person where iPersonID between 1 and 10000
select * from person where iPersonID between 10001 and 20000
select * from person where iPersonID between 20001 and 30000
select * from person where iPersonID between 30001 and 40000
……我也不晓得 ,,。。