Posts, statuses and bookmarks on philipnewborough.co.uk tagged with: "mariadb"
Find more posts tagged with "mariadb" on Mastodon .
I've been running Debian on my servers for years. It's dependable. I guess my server set-up is pretty common, consisting of Apache, PHP and MariaDB, but I figure it is still worth sharing details of how I provision my servers.
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.
Converting a website's back-end to use SQLite, it's currently using MariaDB. I'm interested to see if there will be any performance improvements. The largest table has ~250k rows, so it's not big data, but it's also not insignificant.
My name is Philip Newborough and I’m a full stack web developer living and working in Lincoln, England. This website (philipnewborough.co.uk) serves as my personal homepage. When I’m not working with tech, I love to ride bicycles with my wife and friends.
