帮忙看看这行语句执行为什么这么慢
我有一条把表格里每一个格的内容合并存到一个字符串的语句,执行起来速度相当慢,请大家帮我分析一下原因,或者有什么好的方法把表格内容存到一个字符串里,下面是代码,用了一个vsgrid,
Private Sub Form_Load()
Dim i As Integer
Dim strRow(7) As String
Dim t As Long
Dim j As Integer
Dim TestStr As String
For i = 1 To 1000
strRow(0) = i
strRow(1) = i * 2
strRow(2) = i * 3
strRow(3) = i * 4
strRow(4) = i * 5
strRow(5) = i * 6
strRow(6) = i * 7
strRow(7) = i * 8
For j = 0 To 7
VSFlexGrid1.TextMatrix(i, j) = strRow(j)
Next
'就是下面这句代码,加上他是不加他速度的50倍,在我的电脑上都能运行2秒钟。为什么呢。
TestStr = TestStr & strRow(0) & "|" & strRow(1) & "|" & strRow(2) & "|" & strRow(3) & "|" & strRow(4) & "|" & strRow(5) & "|" & strRow(6) & "|" & strRow(7) & "|"
Next
End Sub