[wp-trac] [WordPress Trac] #19608: tmp table issues

[WordPress Trac]

#19608: tmp table issues
-----------------------------+-----------------------------
 Reporter:  FrederickTownes  |      Owner:
     Type:  enhancement      |     Status:  new
 Priority:  normal           |  Milestone:  Awaiting Review
Component:  Database         |    Version:  3.3
 Severity:  normal           |   Keywords:  has-patch
-----------------------------+-----------------------------
 Of course, WP doesn't scale in use cases where the query response
 necessitates huge tmp tables in order to return.

 The attached patch is far more performant because it uses an index to
 perform the operations rather than taking a huge number of rows and trying
 to operate with them. Although this can be implemented via a few
 functions/filters, I assumed that this patch would address other use cases
 than the ones I had to ameliorate; specifically taxing a very serious
 MySQL cluster and creating tmp tables too large to be written to disk or
 too large to use /dev/shm (memory).

 Originally this patch was written to address issues that become visible
 when several authors were working with posts.php in WP Admin concurrently.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/19608>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software