For many sensors (e.g. humidity, or pressure), frequent recording of values is not required. It is necessary to implement for each sensor the ability to accumulate the average value in the interval set by the user and generate an event only after the specified time (for example, 1 time per hour).
This will reduce the number of records in the “states” table (for example, I have 10 sensors accumulated a 1 million records in a week)
That:s what the filter sensor is for:
Don’t add the underlying sensor to the recorder, instead add the filter sensor.
You didn’t vote for your own FR.