I have been wondering if storing data to a wide database table over a gateway network is a good idea. In my current architecture, I have several Ignition Edge devices in the field that transmit data to a cloud Ignition Gateway in the cloud via MQTT.
Now I know the historian will take into account the store and forward capabilities and that's great but for the wide tables that I store to every so many seconds, if the Edge device loses connection for an hour, that's an hour of data lossed in the wide table.
I'm wondering if that logging to a wide table is best done at the edge using the SFUpdate script to a database in the cloud through the gateway network so that hour of data is buffered in the edge store and forward and then when it connects all those records are inserted in the database with the timestamp of when the data is collected, not stored.
I don't know if that's too much load on the connection between Edge device and the central gateway or not.
Can anyone speak on this?