Remix.run Logo
Remix clone Hacker News
new | show | ask | jobsGithub
▲ snickerdoodle12 5 days ago

Excellent. Now do 42,000x faster please.

▲mort96 5 days ago | parent | next [-]

You never specified a baseline. They could undo their changes and it's 42,000x faster again :)

▲jiggawatts 4 days ago | parent | prev [-]

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 4 days ago | parent [-]

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.