dim db As New ADODB.Connection dim rs As New ADODB.Recordset dim condb As String dim conrs As Stringcondb = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=db; User ID=sa;Password=;Data Source=server conrs = "select sum(amt) as amt1 from table where 多个复杂条件" '表记录200万,统计的记录50万 db.CursorLocation = adUseClient db.ConnectionTimeout = 0 db.Open condb rs.open conrs,db,1,3结果在运行 rs.open conrs,db,1,3 语句30分钟后出现超时,除了运行存储过程,上面的语句能解决普通查询吗?
dim rs As New ADODB.Recordset
dim condb As String
dim conrs As Stringcondb = "Provider=SQLOLEDB.1;Persist Security Info=True;Initial Catalog=db;
User ID=sa;Password=;Data Source=server
conrs = "select sum(amt) as amt1 from table where 多个复杂条件" '表记录200万,统计的记录50万
db.CursorLocation = adUseClient
db.ConnectionTimeout = 0
db.Open condb
rs.open conrs,db,1,3结果在运行 rs.open conrs,db,1,3 语句30分钟后出现超时,除了运行存储过程,上面的语句能解决普通查询吗?