Profiles

  • Member Since: December 24th, 2019
  • Find me on:
  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    As an update while waiting for a developer response, we mitigated impact by leveraging the…

  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    Questioning the state of the world a bit: "SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN…

  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    I now have a working root cause and a partial solution. Root cause: When a…

  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    Did significant more digging into the code base and research of the issue. Looks like…

  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    Thank you. Just to add to this, confirming that the order by gets added starting…

  • Posted a reply to Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    Here is a copy of the explain plan as well: https://maplegrovepartners.com/public/powerpress_query_explain.jpg

  • Created a topic, Custom Podcast Feed INNER JOIN Causes Large Volume of Temporary Tables, on the site WordPress.org Forums:
    We noticed that the following query repeatedly cayuses…