Out of curiosity, Jesse, can you share the query after that change, so it is all stored in this thread for future reference?
On Sun, Jun 2, 2019 at 11:09 PM Jesse Plamondon-Willard < pathosch...@gmail.com> wrote: > Thanks! Performance is much better with that change. > > > On Sun, 2 Jun 2019 at 21:54, Amir Sarabadani <ladsgr...@gmail.com> 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 > Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
