Go home , you're drunk

Add a LIMIT 10: query now runs 9 times slower

Remove a bunch of WHERE clauses (that do not actually affect result count anywhere): query now runs 6 times slower

???

Also I am currently rewriting the monster task query for my datasheet scraper from scratch in an attempt to work around previous ill-conceived query plans, I am probably going to regret this

This is like the 4th full day I am spending on this query by the way

Follow

Getting close to query completion, and it's still running in under 200ms \o/

· · Web · 0 · 0 · 0
Sign in to participate in the conversation
Pixietown

Small server part of the pixie.town infrastructure. Registration is closed.