I think you can assign a different location for the DB file, you can read about it in the recorder component. If you keep to much data it will get slower.
you’re probably right!
Im also running the MAriaDB, without really knowing what to do with it yet, or how to use it. Thought it best to run it from start, and be able later to read the DB when knowing how to configure
no entry on external drives yet though, will study some more. I guess this is the line to elaborate on:
db_url: sqlite:///home/user/.homeassistant/test
should be able to point that to an external drive attached to the Pi.