[jiggawatts]

My record for DB query performance improvement is 13,000:1 and I was called a liar and a cheat to my face and then the customer walked out of the meeting.

I think if someone achieved 42,000:1 they'd be accused of sorcery and burned at the stake.

[rompic]

My best was 5000:1 by updating the outdated SQLite in one of the companies' products.

I found that we were hit by a bug that was fixed 6 years before I discovered it (https://sqlite.org/src/info/6f2222d550f5b0ee7ed). Sqlite's query planner assumed that a field with a not null constraint can never be null, which isn't the case for the right hand table in a left join.