hey @aaron, first of all great work with the High performance SQLite course it's great; really hard to come by all this info, even more so in a single place without having to read a bunch of docs. I'm almost done withe the course, and I was wondering if `UPDATE` statement performance is covered anywhere, so far I've only come upon the `UPSERT` section, but what I've been experiencing from SQLite is that update statements start getting really slow linearly by DB size, and around 1000,000 rows it takes like 250+ms in my own system(very fast gen4 SSDs) when updating a singje row by primary key. Have you noticed this? and do you know of any way to improve performance other than doing a new insert after deleting the old record?
I love how Aaron can build crazy high-quality, high-performance databases, apps, and courses but can't operate OBS.
Haha I don't know if that's an indictment of me or OBS. Let's say OBS.
hey @aaron, first of all great work with the High performance SQLite course it's great; really hard to come by all this info, even more so in a single place without having to read a bunch of docs.
I'm almost done withe the course, and I was wondering if `UPDATE` statement performance is covered anywhere, so far I've only come upon the `UPSERT` section, but what I've been experiencing from SQLite is that update statements start getting really slow linearly by DB size, and around 1000,000 rows it takes like 250+ms in my own system(very fast gen4 SSDs) when updating a singje row by primary key.
Have you noticed this? and do you know of any way to improve performance other than doing a new insert after deleting the old record?