Hi, Thanks for the input! I’m sorry there isn’t more information immediately, this is the only way I could data out to the support team.
I’ve built an application which uses an easy chart and tag historian see Start and End data values for more information on it.
On Thursday last week I was testing the application and response times were very acceptable, perhaps a few seconds to update the easy chart when dates were changed. Friday I went to setup this on the managers desktops and the application comes up with these really long SELECT queries leading to timeouts in the order of 20+ minutes.
I’m checking back to see if anything changed with the scripting or database, I might need to get the IT guys involved as they made changes to firewall rules to allow managers access to the production network.