[wp-trac] [WordPress Trac] #17998: New Site & Upgrade process uses unrestricted "show all" causing timeouts

[WordPress Trac]

#17998: New Site & Upgrade process uses unrestricted "show all" causing timeouts
--------------------------+------------------
 Reporter:  brianlayman   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.3
Component:  Database      |     Version:  3.2
 Severity:  major         |  Resolution:
 Keywords:  has-patch     |
--------------------------+------------------

Comment (by inxilpro):

 We've had similar issues, but they're due to the fact that our data is
 sharded, so each table may be in a different database or a different
 server.  This means that just running `SHOW TABLES` and then looping
 through them will never work.  The only solution that I can think of is to
 loop through each table in `$cqueries` and check that table's existence
 individually.  It's not as performant, but it opens a spot for plugins
 like HyperDB to route that query to the right database.

 Thoughts?

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