5 ms·
Excellent. Now do 42,000x faster please.
by snickerdoodle12 1y ago
Excellent. Now do 42,000x faster please.
- mort96 1y agoYou never specified a baseline. They could undo their changes and it's 42,000x faster again :)
- jiggawatts 1y agoMy 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 1y agoMy 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 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.