Speed Test - Loop vs CopyMemory

[dglienna]

You still have to loop to copy memory, don't you? Or are you going to read a large block at once to copy 4K of info? That may be the problem.

[moeur]

Copymemory is much faster.
It is more difficult to move the array up than down

'move array up
   '1st to temp array
   CopyMemory temp(LBound(temp)), arr(LBound(arr)), (UBound(arr) - 1) * Len(arr(UBound(arr)))
   'back to our array
   CopyMemory arr(LBound(arr) + 1), temp(LBound(temp)), (UBound(arr) - 1) * Len(arr(UBound(arr)))
   
   'move array down
   CopyMemory arr(LBound(arr)), arr(LBound(arr) + 1), (UBound(arr) - 1) * Len(arr(UBound(arr)))

[dw85745]

moeur

Thanks for taking your time to respond and pointing out my error.

I'm still not convinced CopyMemory is faster. From my testing so far,
like most things it depends. If you have multiple arrays then the loop
may be faster than multiple calls to CopyMemory.

From the tests I've run so far, the Loop = CopyMemory till around 12000 elements (at least will 5 arrays), then CopyMemory wins.

Attached is a revised example.

David.