Building a Life OS

Building one system to rule them all.
Follow me:
Twitter: / aarondfrancis
LinkedIn: / aarondfrancis
Website: aaronfrancis.com - find articles, podcasts, courses, and more.

[@dalcod]

I love how Aaron can build crazy high-quality, high-performance databases, apps, and courses but can't operate OBS.

[@aarondfrancis]

Haha I don't know if that's an indictment of me or OBS. Let's say OBS.

[@edgarsilvax]

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?