You are reading a single comment by @Murphy's_Law and its replies.
Click here to read the full conversation.
Murphy's_Law-
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.
Velocio
Try it now :)