[wp-trac] [WordPress Trac] #54346: Slow SQL queries fetching posts from specific categories

[WordPress Trac]

#54346: Slow SQL queries fetching posts from specific categories
-------------------------------------------------+-------------------------
 Reporter:  Krstarica                            |       Owner:
                                                 |  craigfrancis
     Type:  enhancement                          |      Status:  accepted
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Database                             |     Version:
 Severity:  normal                               |  Resolution:
 Keywords:  needs-testing has-patch has-unit-    |     Focuses:  rest-api,
  tests                                          |  performance
-------------------------------------------------+-------------------------
Changes (by craigfrancis):

 * owner:  (none) => craigfrancis
 * status:  assigned => accepted


Comment:

 Yep, will try this weekend.

 @Krstarica or @joseaneto, would you be able to email the following to me
 (craig at craigfrancis dot co dot uk):

 1. The `EXPLAIN` output for this query, i.e. `EXPLAIN SELECT wp_posts.ID
 ...`;
 2. The output from `SHOW CREATE TABLE wp_term_relationships`;
 2. The output from `SHOW CREATE TABLE wp_posts`;
 3. Number of records you have in these tables (joseaneto, I believe you
 had "+500,000 records in the posts table" in December 2021).

 I'll try to work out what's happening, and report back here.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/54346#comment:18>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform