When does the Delete Records task of an SQL Transaction Group run?

Ignition
1

I’m experimenting with Transaction groups. I have data being logged to a table at the rate of 1 sample per second. I noted that with the “Delete records older than” option that:

  1. When the limit was set to older than 1 minute, I would see up to 120 rows in the table IE 2 minutes worth of data

  2. When the limit was set to older than 2 minutes, I saw over 200 rows in the table IE more than 3 minutes worth of data.

So what is the criteria for triggering a data deletion? Is it something like: 1 minute after number of rows has reached the limit? Or is it more involved?

2

Here you go. :slight_smile:

1 Like
3

I’ll take it