[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:  new      
 Priority:  normal        |   Milestone:  3.1      
Component:  Database      |     Version:           
 Severity:  critical      |    Keywords:  has-patch
--------------------------+-------------------------------------------------

Comment(by ryan):

 I did some quick profiling of a typical front page request with 6 posts.
 The patch reduced peak memory usage a small amount ( 14,912,496 before vs.
 14,877,440 after).  Short apache bench runs show the patch to be a bit
 faster.  I haven't noticed any bugs so far.

 I'll try testing with some big result sets to see how peak memory usage
 behaves.

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