谢谢楼上各位的指点 那么下面这两句分页哪一个效率更高呢 或者还有更好的方法? select first (10) * from TSCSJ where (xh not in (select first 10 xh from tscsj order by xh)) order by xh select first(10) * from TSCSJ where xh>(select max(xh) from TSCSJ where xh in (select first 30 xh from tscsj order by xh)) order by xh
多线程不是想象的那么好其实LZ可以考虑定时读取 或者如myceolzy 所说
把这个datatable赋值给datagridview,让后,在后台设置一个线程,
不停的读取剩余的数据,然后增量添加到datatable里,
http://topic.csdn.net/u/20100519/23/a76f56f0-b794-476e-a996-f23573af8667.html
那么下面这两句分页哪一个效率更高呢
或者还有更好的方法?
select first (10) * from TSCSJ where (xh not in (select first 10 xh from tscsj order by xh)) order by xh
select first(10) * from TSCSJ where xh>(select max(xh) from TSCSJ where xh in (select first 30 xh from tscsj order by xh)) order by xh