[wp-trac] [WordPress Trac] #26419: maybe_create_table is very resource intensive

[WordPress Trac]

#26419: maybe_create_table is very resource intensive
-------------------------+-----------------------------
 Reporter:  codix        |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Database     |    Version:  trunk
 Severity:  normal       |   Keywords:
-------------------------+-----------------------------
 SHOW TABLES is a very resource intensive query, specially in multi site
 setup where there will be many tables in a given database. It's worse when
 you run through all the tables in the database to see whether the table
 exists.

 Instead I propose SHOW TABLES LIKE which will achive the same thing much
 more effiently.

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