一表(tab1)中有十几万条记录。现要ADO打开一recordset
sql语句是
SQL = "select * from tab1 where OrderNo='111' and Status<'50' "
打开太慢,我把Status<'50'改成Status='50'则打开非常快,如何提高速度?
谢谢!
sql语句是
SQL = "select * from tab1 where OrderNo='111' and Status<'50' "
打开太慢,我把Status<'50'改成Status='50'则打开非常快,如何提高速度?
谢谢!
不然SQL = "select * from tab1 where OrderNo='111' and Status='50' "
也慢
不必要的话不要SELECT *,而是指定需要的字段;
select 有用的字段