HA speed, Lots of devices, How to tell if I need to upgrade

I can’t imagine it’s the bulbs that contribute a significant part of the history.

FWIW, this post expands on mryckman’s suggestion:

How to reduce your database size and extend the life of your SD card - Community Guides - Home Assistant Community (home-assistant.io)

Here’s me giving someone the same advice mryckman gave you (my production server stores to disk but my test server stores to memory). I also included a sample of how I configured recorder so that it only records history for what interests me.