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.

Status

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.

datatables mariadb php sqlite

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.

mariadb sqlite

Philip Newborough and a donkey enjoying a beer.

About

My name is 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.

← An IndieWeb Webring πŸ•ΈπŸ’ β†’