[wp-trac] [WordPress Trac] #41223: wp_posts are very slow on larger sites

[WordPress Trac]

#41223: wp_posts  are very slow on larger sites
--------------------------+------------------------
 Reporter:  lubimow       |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:
 Severity:  normal        |  Resolution:  duplicate
 Keywords:                |     Focuses:
--------------------------+------------------------
Changes (by pento):

 * status:  new => closed
 * version:  4.8 =>
 * resolution:   => duplicate
 * milestone:  Awaiting Review =>


Comment:

 Thanks for the ticket, @lubimow!

 This still has the same answer as #7633 - we don't select by the guid
 field in Core, so won't be adding an index to fix this.

 As @jrchamp suggested, a custom index would help - perhaps on `(guid,
 post_type)`, going by the query to posted. This will help if you're using
 MyISAM, InnoDB, or just about any other database engine.

 That said, I would strongly recommend contacting the plugin author
 directly, they're welcome to add an index that helps their queries, though
 it's generally better to rewrite the query to use already indexed columns.

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