[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
--------------------------+-------------------------------------------------
Changes (by hakre):

  * keywords:  dev-feedback has-patch => has-patch


Comment:

 I like the idea, once while doing #11799 I did change the local store of
 the resultset from an array of objects to a plain array which already
 helped.

 Using a resulset cursor is helping even more memory wise as normally the
 resultset is mostly requested once from wpdb so no need to store the
 duplicates.

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