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

[WordPress Trac]

#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


Comment:

 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