History Slowly

Hello, I have a bad performance in a to read a history tag only when the start date is older then 2 weeks (I have a new table even 2 weeks) and the same period (24 hours).

For example if I select yesterday in 1 second I have my dataset completed, but if I select one month ago it takes 30 seconds and more.

Is possible to improve the performance?


It might be worth looking into the underlying cause of the slowness, but I suspect the queries themselves are taking a while to run. You can monitor this from “Status > Databases” on your gateway webpage.

Is anything else hitting your database server, or is Ignition hitting it particularly hard?

You could try the standard sort of options like pruning data, using preprocessed partitions, etc. Out of curiosity, how many rows are in your sqlth_sce table?