Why is default recorder so sluggish?

The default database is SQLite not MySQL. SQLite is not recommended for working with lots of data and high write volumes.
Check “When Not TO Use SQLite” here.

What I would recommend is, to start excluding entities, for which you don’t need any history like sun.sun or sensor.time.
Check this thread here.