Improving Alarm Journal Query Performance

Ignition
1

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

2

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

3

It is running on the client.

4

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