Thanks! Performance is much better with that change.
On Sun, 2 Jun 2019 at 21:54, Amir Sarabadani <ladsgroup(a)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.