Trigger Resetting in SQL Bridge Module

[ryan.white]

@pcryer

I have my tags set to poll every 50ms

Look at your device status screen on the gateway. What is the overload factor on the 50ms poll group? I would bet money its more than 0%. Normally Ignition's drivers don't do well beyond 250ms, if you have pturmel's ethernet/IP driver, you can get to 100ms with work done on the PLC side for optimization.

Consider the approach outlined in this post:

How to batch/buffer fast data before working with them

Code and data structures from PLC through SCADA to DB that hold critical information that simply cannot be allowed to fall into the bit bucket on the floor. Usually configured to hold in the PLC some small multiple of the maximum connection downtime that can be predicted for the overall system. Data is delivered, usually many pieces in parallel, through SCADA to the high-reliability database, where each piece of data gets a distinct handshake to the PLC after its insert transaction succeeds. …

It basically boils down to having a ring buffer in your PLC that stores enough data for x seconds of runtime and offloads in smaller chunks of y seconds at slower poll rate in Ignition. This does mean scripting the transaction instead of using the SQL bridge module.