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 <pathoschild@gmail.com> wrote:
Thanks! Performance is much better with that change.

On Sun, 2 Jun 2019 at 21:54, Amir Sarabadani <ladsgroup@gmail.com> wrote:
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.

Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly labs-l@lists.wikimedia.org)