SystemReady = False
DataTables("物料").ReplaceFor("名称","")
DataTables("物料").ReplaceFor("规格型号","")
DataTables("物料").save
Dim st As Date = Date.Now '要测试耗时的代码
Dim drs As List(Of DataRow)
Dim drbs As List(Of DataRow)
drs = DataTables("物料测试").Select("测试 = true")
Dim alldrs As New Dictionary(Of List(Of DataRow), DataRow)
For Each dr As DataRow In drs
drbs = DataTables("物料").SQLSelect("[代码] = '" & dr("代码") & "'")
For Each drb As DataRow In drbs
drb("名称") = dr("名称")
drb("规格型号") = dr("规格型号")
Next
DataTables("物料").SQLUpdate(drbs)
Next
SystemReady = True
msgbox("完成耗时:" & Format((Date.Now - st).TotalSeconds,"0.0000") & "秒")
这段代码更新 300条后台数据显示 要 25秒 如何优化才能加快速度