|
话题源于贴: http://club.excelhome.net/forum. ... tid=995573#lastpost
2楼Zamyi的点评
“Zamyi: 动态数组并不慢,而是ReDim Preserve慢。”
之前对动态数组的理解有偏差。
经过测试,证实动态数组在变动少的情况下速度与固定数值差别不大。
在此感谢Zamyi指点。
三人行必有我师。
附测试代码:
固定数组测试:- Sub ArrayTest1()
-
- Dim arr(9999) As Long
- Dim t
- Dim i As Long, j As Long
-
- t = Timer
- For j = 1 To 1000
- For i = 0 To 9999
- arr(i) = i
- Next i
- Next j
- t = Timer - t
- Debug.Print t '.1757813秒
-
-
- End Sub
复制代码 动态数组测试- Sub ArrayTest2()
-
- Dim arr() As Long
- Dim t
- Dim i As Long, j As Long
-
- ReDim arr(9999) As Long
- t = Timer
- For j = 1 To 1000
- For i = 0 To 9999
- arr(i) = i
- Next i
- Next j
- t = Timer - t
- Debug.Print t '.1875秒
-
-
- End Sub
复制代码 |
|