-
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…