.net 2007数据库性能分析(插入)

 Using c As New capsulecn.conn("a2007")            Dim d As DateTime = Now()            For i As Integer = 1 To 1000                c.executecomm("INSERT INTO [table] (id2, str) VALUES (?, ?)", New Object() {i, "xuyue" & i})            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("INSERT INTO [table] (id2, str) VALUES (?, ?)", New Object() {i, "xuyue" & i})            Next            Debug.WriteLine(Now().Subtract(d))        End Using

即时窗口

00:00:00.4843750
00:00:00.3906250