[wp-trac] [WordPress Trac] #19608: tmp table issues
WordPress Trac
wp-trac at lists.automattic.com
Mon Dec 19 06:39:46 UTC 2011
#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
More information about the wp-trac
mailing list