[wp-trac] [WordPress Trac] #14397: slow sql query from probably is_blog_installed

[WordPress Trac]

#14397: slow sql query from probably is_blog_installed
--------------------------+-------------------------------------------------
 Reporter:  mark-k        |       Owner:                 
     Type:  defect (bug)  |      Status:  new            
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Performance   |     Version:  3.0            
 Severity:  normal        |    Keywords:  has-patch      
--------------------------+-------------------------------------------------

Comment(by wpmuguru):

 Replying to [comment:4 jimmcq]:
 > A query like "SELECT COUNT(*) AS count FROM information_schema.tables
 WHERE table_schema = '$database' AND table_name = '$tablename'"

 I don't think we can rely on every install having access to
 information_schema.

 @Ryan - Would "SHOW CREATE TABLE $wpdb->options" and iterate through the
 nine tables do the trick?

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