You can configure an SQL table logger to flush data to the database using either a schedule or a data threshold. A schedule flushes data to the database based on a time schedule, while a data threshold flushes data to the database upon receiving a specified number of events. It is strongly recommended that you use a schedule rather than a data threshold.

To enable in-line flushing using a data threshold, set the value of the dataItemThreshold property to whatever threshold you want. A threshold of 10 means that the SQL table logger flushes its data after receiving 10 events.

For best performance in production systems, use a schedule to control your flush operations, and not a dataItemThreshold. The schedule frequency should be tuned based on the rate at which data is being fed to the SQL table logger. Configure the schedule with the scheduler and schedule properties. For example:

schedule=every 3 minutes