# 各位高手帮帮忙!!!!!!

Posted by 无解之人 on August 04, 1999 at 18:10:50:

server 为 PIII 450 128MB RAM (NT4.0+SQL7.0)
工作站为 PIII 450 128MB RAM(VB6.0)
内部网路为 100MB
connstr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=LONG3;Data Source=MIS-NT"
connr.Open connstr
rs1.CursorLocation = adUseServer
rs1.Open "select * from 商品主档 order by 货号", conn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rs1

商品主档大约有 一万三千多笔资料
则开启时间需 20-30秒

为何会这么慢,简直不可接受

Follow Ups:

- Re: 各位高手帮帮忙!!!!!! Arthur 19:23:09 8/04/99 (1)
  - Re: 各位高手帮帮忙!!!!!! 陈春雨 23:12:52 8/04/99 (0)