Description

Find out what the settings in the Store and Forward system mean. Each database connection has its own Store and Forward settings.

Video recorded using: Ignition 7.9

Transcript

(open in window)

[00:00] Let's take a look at the settings for a Store and Forward engine. I'm on my gateway, I'm in the Configure section under Databases and Store and Forward here, and you can see I have several engines already defined. You'll notice the note down below that a Store and Forward engine is automatically created for each database connection, so as soon as I add a new connection, a new engine will appear here. Now before moving on, it's important to know that many objects and subsystems in Ignition utilize the Store and Forward system, such as the alarm journal. Some of these systems also have settings to skip or completely bypass the Store and Forward system. Now let's take a look at some of the settings here. All three of these engines have the same settings, so it doesn't really matter which one I click on, but I'll start with my MySQL. I'll click on the Edit button here and we'll start talking about these properties. The Memory Buffer Size here dictates how many records can be held within the memory buffer. I'll scroll down here just a little bit and let's take a look at the Store Settings next. These settings dictate when we should take records from the memory buffer and move them to the disc buffer. The Disk Cache Enabled setting here. If disabled, Ignition will no longer store records onto the hard drive. So if the memory buffer becomes full, you could lose records. While the Disk Cache is enabled, the Max Records property here dictates the maximum number of records that will be saved to the hard drive. And then we have the Write Size and Write Time properties. These are used to determine when to move the memory buffer to the disc buffer. With the default settings, we'll wait until there are 25 records or at least 5,000 milliseconds have passed, whichever one of these two becomes true first. If we scroll down a little bit further here, we can take a look at the Forward settings. These settings control how often we take records from either buffer and move them to the database. We have another Write Size and Write Time, which work in a very similar fashion to the Store settings up above. So again, we'll wait until there are at least 25 records in a buffer or until we've had items in the buffer for at least 1 second. Once these are true, then the records are pushed to the database. And again, this is for both buffers. If you look down a little bit further, you can enable a schedule and then define when you want that schedule to run. This means that Ignition will not write anything to the database until the scheduled time. This gives you an opportunity to control when you're pushing your data into your database.

You are editing this transcript.

Make any corrections to improve this transcript. We'll review any changes before posting them.