[wp-trac] [WordPress Trac] #15170: Network admin pages don't scale

[WordPress Trac]

#15170: Network admin pages don't scale
--------------------------+-------------------------------------------------
 Reporter:  ryan          |       Owner:  ryan           
     Type:  defect (bug)  |      Status:  assigned       
 Priority:  normal        |   Milestone:  3.1            
Component:  Multisite     |     Version:  3.1            
 Severity:  normal        |    Keywords:  ongoing-project
--------------------------+-------------------------------------------------

Comment(by ryan):

 {{{
 $query .= " AND ( {$wpdb->blogs}.domain LIKE '%{$like_s}%' OR
 {$wpdb->blogs}.path LIKE '%{$like_s}%' ) ";
 }}}

 That is a killer query on large sites.  We should probably lose the %s and
 saerch for $like_s.domain for subdomain installs and domain/$like_s for
 subdir installs.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15170#comment:8>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software