I've been playing around with converting a website's database from MariaDB to SQLite. SQLite is consistently 100 - 200ms faster when performing search queries on a table with ~100,000 rows using DataTables and PHP. There doesn't appear to be any noticeable speed difference querying individual rows. Also, I'm not sure if I'm being a bit heavy handed with it, but I've managed to corrupt the SQLite db numerous times, which is concerning.
Folksonomy: mariadb
Posts, statuses and bookmarks on philipnewborough.co.uk tagged with: "mariadb"
Find more posts tagged with "mariadb" on Mastodon .
Blog
No blog posts tagged with mariadb.