For this kind of application, my own experience and others using home assistant seems to be your much better of plugging an SSD into the pi’s USB 3 and using that. It’s also really important to use a good power supply.