I've had my HA running on an RPi with a regular A1 SD card for close to 3 years now, and my ZWave log file is spammed and my database is 2GB, so not lack of activity.

I did experience some issues initially, but found it was due to a poor USB "charging" cable, it had 1 Ohm resistance! After swapping that it's been just smooth sailing.

I do take frequent backups to my NAS just in case though.