BackGround: I have ignition as a tool to develop the operator interface to collect realtime data from production line. With more and more app develped, sql resource become a big issue
the following picture is my sql activity’s execution picture
here is my sql activity read picture
i found there have a very big read action, perhaps that is the reason that make all my other query wait for a long time
this table RPL_DATA1 currently have 600K lines
these tag is Event Driven, almost have 100 these kind of tags in the Gateway.
(because I have 9 machine, I firstly prepare them on the gateway tag, then use indirectly binding to show them on the vision)
I don’t know why these 100 event driven tag will make the ignition tag’s sql function almost go wrong,
What should I do to improve the software structure and make ignition more stable ?