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.

Thanks,
Brandon

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