[wp-trac] [WordPress Trac] #41714: wp_list_pages() - horrible performance due to eventual "SELECT *"

WordPress Trac noreply at wordpress.org
Thu May 16 12:22:49 UTC 2019


#41714: wp_list_pages() - horrible performance due to eventual "SELECT *"
-------------------------------+------------------------------
 Reporter:  DavidAnderson      |       Owner:  (none)
     Type:  defect (bug)       |      Status:  new
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Posts, Post Types  |     Version:  4.9
 Severity:  normal             |  Resolution:
 Keywords:  2nd-opinion        |     Focuses:
-------------------------------+------------------------------

Comment (by DavidAnderson):

 @garrett-eclipse Thank you.

 @arena Adding indexes to the table is not going to make any difference to
 `SELECT *` making MySQL send over all that's in `post_content` when all
 that was ultimately wanted through the initial API call made was a list of
 post titles and URLs.

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


More information about the wp-trac mailing list