How to precisely measure function execution time

Ignition
1

hi
I have a piece of code which is quite slow (the code interacts with the database) and need to measure its execution time to know if i make it quicker or slower. Could you please share what tools would you use to measure it?
Best Regards and thanks for your great help so far!

2

The easiest would be to add some system.date functions at the beginning and end of the function.

def myFunc():
    start = system.date.now()
    ....
    end = system.date.now()
    execTime = system.date.millisBetween(start,end)

millisBetween() should work in most cases, but if you need something for faster scripts you could use
java.lang.System.nanoTime().

1 Like
3

Likely that the database is the source of your slowness, depending on what you define as "slow".

I would make sure you/or someone, look at the indexing of involved tables, and query execution plan. DB queries are notorious for unexpected performance issues.

For code execution time, I always use java.lang.System.nanoTime()

from java.lang import System

start = System.nanotime()
# your code
end = System.nanotime()
print 'Took {} nanosecodes'.format(end-start)
4

that will do the trick thank you

5

Always use System.nanoTime() for benchmarking. It uses a monotonic clock that is synchronized across processors, and is immune to system clock adjustments. If your thread gets interrupted and migrated, .nanoTime() will be most consistent.

1 Like
6

thanks a lot for your feedback