[wp-trac] [WordPress Trac] #12257: wpdb Scales Badly Due to Unnecessary Copies of All Query Results

[WordPress Trac]

#12257: wpdb Scales Badly Due to Unnecessary Copies of All Query Results
------------------------------+---------------------------------------------
 Reporter:  miqrogroove       |        Owner:  ryan    
     Type:  defect (bug)      |       Status:  reopened
 Priority:  normal            |    Milestone:  3.1     
Component:  Database          |      Version:          
 Severity:  critical          |   Resolution:          
 Keywords:  has-patch commit  |  
------------------------------+---------------------------------------------
Changes (by nacin):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 Tried to create a new site via site-new.php. Got an Already Installed
 notice. This appears to be taking place in install_blog(), on the query
 get_results(SELECT ID FROM $wpdb->post), which instead of evaluating to
 empty, what's being returned is array( 0 => false ). Slight error there.

 I can't reproduce outside of that specific instance, but it's related to
 this change.

 Speaking of, that query is crap, and should be SHOW TABLES or get_var or
 something. Leaving it alone so we can track down the change in
 functionality.

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