.net 2007数据库性能分析(更新)

        Using c As New capsulecn.conn("a2007")            Dim d As DateTime = Now()            For i As Integer = 1 To 1000                c.executecomm("UPDATE [table] SET id2 = ?, str = ? WHERE (ID > 100000)", New Object() {1, "xuyue1"})            Next            Debug.WriteLine(Now().Subtract(d))        End Using        Using c As New capsulecn.conn("a2003")            Dim d As DateTime = Now()            For i As Integer = 1 To 1000                c.executecomm("UPDATE [table] SET id2 = ?, str = ? WHERE (ID > 100000)", New Object() {1, "xuyue1"})            Next            Debug.WriteLine(Now().Subtract(d))        End Using

即时窗口

00:00:25.2187500                
00:00:21.6406250