[wp-trac] [WordPress Trac] #14593: wp_load_core_site_options() query optimization

WordPress Trac wp-trac at lists.automattic.com
Thu Aug 12 18:26:35 UTC 2010

#14593: wp_load_core_site_options() query optimization
 Reporter:  ellisgl       |       Owner:                         
     Type:  defect (bug)  |      Status:  new                    
 Priority:  normal        |   Milestone:  Awaiting Review        
Component:  Optimization  |     Version:  3.0.1                  
 Severity:  trivial       |    Keywords:  needs-testing has-patch
Changes (by mrmist):

  * keywords:  => needs-testing has-patch


 OK.  I guess it depends on what else goes into the multi-site meta table
 as to how big that particular table might get.  What I'm trying to say is
 that for, say, 10 rows it's probably more expensive to do the lookup, and
 that's why the index is ignored in the first place.  Some execution data
 from large and small sites with or without the patch might be worthwhile
 to decide whether the index should be forced or not..

 Sadly I don't have a multi-site install to test on, big or small.

Ticket URL: <http://core.trac.wordpress.org/ticket/14593#comment:6>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software

More information about the wp-trac mailing list