Folksonomy: datatables

Posts, statuses and bookmarks on philipnewborough.co.uk tagged with: "datatables"

Find more posts tagged with "datatables" on Mastodon .

Blog

No blog posts tagged with datatables.

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

Bookmarks

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 🕸💍 →