[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  |  
------------------------------+---------------------------------------------

Comment(by joelhardi):

 I don't use multisite so can't be much help in tracing this.

 I did verify that

 {{{
 $wpdb->get_results("select id from wp_posts;");
 }}}

 where wp_posts is an empty posts table returns an empty array (which
 evaluates to FALSE), which is what it's supposed to. So, if you're instead
 getting array( 0 => false ) I would guess that this issue relates to code
 that switches wpdb from one blog to another? Which doesn't make sense
 because this patch didn't go anywhere near that code in wpdb.

 I don't see anything in switch_to_blog() ... unless there's something
 triggered when the "switch_blog" action fires.

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