I just converted a site over from Mariadb to SQLite and it feels quite a bit snappier so far. I used https://github.com/dumblob/mysql2sqlite for conversion.