Hello,
There are many solution but I personally like influxdb.
I am running about 50 sensors for more than 2 years without any retention issue.
If the home assistant db becomes huge it can create issue or slow down.
At beginning of my journey I have read this post: https://community.home-assistant.io/t/how-to-keep-your-recorder-database-size-under-control/295795
Depending on what you want to achieve keep in mind the purge default time here the docs: https://www.home-assistant.io/integrations/history/#:~:text=By%20default%2C%20the%20recorder%20stores,is%20taken%20from%20the%20recorder.