You are reading a single comment by @danb and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
danb
Velocio
https://github.com/microcosm-cc/microcosm/commit/03f41f95e9039a0f519caefea7d5b1da4e098a8a
It's... weird.
50% came from me changing a JOIN to stop referring to another JOIN table, prevents a huge amount of temporary data.
50% came from moving some fields to the inner SELECTs and removing an outer SELECT and JOIN.
It's pretty trivial stuff though, stuff I would've hoped the optimiser would catch.