老师,这个存储过程在数据库内执行是0.1秒都不到,绑到窗口上,耗时7秒多,会卡,
数据库上加了索引,索引去掉了排序
CREATE INDEX OrderMainIndex
ON OrderMain([_Identify],[Cl_PurSaleMold],[Order_ID])
但查询依旧很慢,数据量大后,会比较卡
Dim Cmt As String = Args(0) '存储过程名
Dim Cmt_c As String = Args(1) '传入的存储过程参数
Dim Tbnm As String = Args(2) '生成接收表名
Dim FTbnm As Table = Args(3) '查找表名表头
Dim cmd As new SQLCommand
cmd.Connection Name = "数据库名"
cmd.CommandText = Cmt
cmd.StoredProcedure = True
If Cmt_c <> "" Then
cmd.Parameters.Add("@_IDNo",Cmt_c)
End If
Tables(Tbnm).DataSource = cmd.ExecuteReader()
Tables(Tbnm).AutoSizeCols()