We have a project where data is coming in for a particular set of devices from a SQL table (the devices themselves write the data into the database table) which is read-only for SCADA.
What is the most efficient way to get this data into tags in Ignition for use in templates and other components? There will be 21 tags per device, and 3 devices (63 tags altogether):
- a query tag for each data point, each querying the SQL table for the data they’re looking at (63 queries per x seconds - probably 10s, not sure yet update rate)
- a single query performed in a script (gateway event or gateway tag change) and then script writes to the device memory tags
- something else
To me from a performance and efficiency point of view, I would choose the 2nd option. It’s not as simple to roll out.
Am I right in my choice?