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:
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
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?