That’s fine as long as you don’t want more than about 10 days of history. Recorder’s default storage duration for the state history of all entities is 10 days (older data is discarded).
What I proposed stores data in a separate table within the database that is not purged and can accumulate indefinitely.