Thanks! Performance is much better with that change.
On Sun, 2 Jun 2019 at 21:54, Amir Sarabadani <[email protected]> wrote: > Hey, > One important optimization you can use and it's often missed out (and it's > going to be needed more as we normalize more tables) is join decomposition. > It basically means you don't join and query but do two (or several) queries > separately in your code. This might seem counter intuitive but it's pretty > useful for several reasons (like MySQL will cache the normalizing table and > answer faster or you yourself can cache some parts). You can read more > about those in "High Performance MySQL" book. > > HTH >
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
