Depends on if you cache or read/write constantly. Pretty sure .json files are cached in memory and only written to as needed. SQLite databases would be constantly read/written to.
I don't know about the sqlite implementation Oxide uses, but usually SQLite does perform caching (see SQLite Optimization | Performance FAQ).
