Transformed query taking >200 seconds down to 0.5s

  • Gave us a huge improvement on site with a large postmeta table (more than 33 million rows).

    A third party plugin was making 2 multi-join queries with the postmeta table (10 joins on the table). Each query was taking 4-5 minutes to complete.

    After indexing those queries dropped to just 0.5 seconds to complete.

    Haven’t checked the size increase on the DB, but the speed improvement is fantastic.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    That’s great to hear. Thanks for letting us know your results.

    (The new keys probably do take a lot of SSD / HDD space in your DBMS, but that’s the classic time-space tradeoff. Although processors aren’t getting faster, SSD / HDD space is getting dramatically cheaper with each passing year.)

    @olliejones just gotta mention here that I really like your attitude and your writing skills. You are marvelous, and what you are doing for the WordPress community will be remembered. Thank you for what you do!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Transformed query taking >200 seconds down to 0.5s’ is closed to new replies.