# 为何开启2000笔之资料需要20-30秒(ADO+SQL)

Posted by 等待救命之人 on August 02, 1999 at 15:21:04:

请问我用ADO开启SQL之资料档
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LONG3;Data Source=LONG-NT"
conn.Open connstr
rs1.CursorLocation = adUseClient
rs1.Open "商品主档", conn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rs1

资料大约2000笔为何需20-30秒

Follow Ups:

- Re: 为何开启2000笔之资料需要20-30秒(ADO+SQL) 大汉堡 16:34:43 8/02/99 (0)