speedcheck - calculates a functions runtime in ms (4 code-optimization)
No attachments for this post
Just one line of code is needed to test a functions speed -> With this class-module.
It creates an object which is automatically terminated together with the function you check and it uses debug.print to let you know how long your pc had been busy (in ms) with that function.
Sure you can save the value of timer() and read it before your function reaches exit/end function, but its harder to remove this before you release your app... So try this!
Original Author: Max Christian Pohle
Dim A as New <Object> is slower than Dim A as <Object>: Set A = New <Object>
'Create a new Class-Module for this
'and call it "SpeedCheck":
Private Declare Function GetTickCount Lib "kernel32.dll" () As Long
Private StartPoint As Long
Public Property Get CurRunTime() As Long
RunTime = GetTickCount - StartPoint
Private Sub Class_Initialize()
StartPoint = GetTickCount
Private Sub Class_Terminate()
Debug.Print "- - - - - Your function needed: " & GetTickCount - StartPoint & " ms"
'This is just an example to use it...
'Its as easy as possible-
'therefor I do not use option explicit here
'and I work with a slow variant-datatype :-)
Private Sub Form_Load()
Dim A As SpeedCheck: Set A = New SpeedCheck
For I = 0 To 1000
Debug.Print "Debug-Print is very slow!"
Comments on this post
No comments have been added for this post.
You must be logged in to make a comment.