Improving Alarm Journal Query Performance

I have a script that combines both the audit event table and the alarm journal data into one table. I found that the window runs very slowly and it turns out that system.alarm.queryJournal takes 70% of the execution time for the entire script.

Has anyone found a method to improve the response time from this function? I am only trying to query a period of two hours but it takes 12-15 seconds to complete.


Is the script running on the gateway or on the client?

It is running on the client.

Iā€™d suggest moving it to the gateway to offload the heavy lifting from the client. You could put the script in a timer script or message handler and write it to a memory tag that populates the table.

1 Like