Folksonomy: sql

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.

This morning I am mostly writing SQL queries for reports. I've also converted values in a db table column from plain text to json strings to allow for multiple values. Feels a bit hacky, but works ok. Should probably create another table at some point.