[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.0         
Component:  Database      |     Version:              
 Severity:  critical      |    Keywords:  dev-feedback
--------------------------+-------------------------------------------------
Changes (by prettyboymp):

 * cc: mpretty@… (added)


Comment:

 I don't know that this should/can be changed.  All it is doing is copying
 the mySQL result into the PHP space.  The only work around I could think
 of would be if any time a multi-row query result was needed, the result
 would have to follow an iterator interface, which then requires reworking
 of everything.

 Queries shouldn't be returning this large of result sets.

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