[wp-trac] [WordPress Trac] #8977: Database schema upgrades can be inefficient with lots of database tables because of maybe_create_table() function

[WordPress Trac]

#8977: Database schema upgrades can be inefficient with lots of database tables
because of maybe_create_table() function
--------------------------+-------------------------------------------------
 Reporter:  jamescollins  |       Owner:     
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  2.8
Component:  Upgrade       |     Version:  2.7
 Severity:  normal        |    Keywords:     
--------------------------+-------------------------------------------------
 The {{{maybe_create_table()}}} function in {{{wp-
 admin/includes/upgrade.php}}} performs a {{{SHOW TABLES}}} query (which
 returns every table in the database) then loops over all of these to see
 if a the specified table exists.

 WPMU was recently modified to optimise this, and donncha has suggested
 that this fix be implemented in WP as well.

 (See [http://trac.mu.wordpress.org/ticket/833 WPMU Trac Ticket #833] for
 more information)

-- 
Ticket URL: <http://trac.wordpress.org/ticket/8977>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software