Also make sure that your SQL tables are properly indexed for the selects that you are performing.
Thanks, yes, tables are idexed by most usig column. I am more better in databases then Ignition background.
Time to time I have issue with opc tag. I wond change tag from tag change value script.
And it term 3second. Same instruction from Script Console is immediatelly. And all receurses in server and gateway sleeping.
There is a limited thread pool for tag events. Sleeping or performing long scripts ties up a thread. Do very much of that and your tag system stops or slows way down.
Consider using a gateway tag change event (under project scripting) instead of a tag event. Then you’ll have an option for a dedicated thread.
OK, I will test in in most problematic tag, then will see