WordPress.org

Make WordPress Core

Changes between Initial Version and Version 19 of Ticket #18536


Ignore:
Timestamp:
12/19/2011 03:17:26 PM (10 years ago)
Author:
nacin
Comment:

Removing the screenshot (dead link). I do remember the graph looking mighty impressive, though.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #18536

    • Property Cc xoodrew@… aaroncampbell anointed added
    • Property Keywords early added
    • Property Component changed from Query to Performance
    • Property Milestone changed from Awaiting Review to 3.4
  • Ticket #18536 – Description

    initial v19  
    55I have implemented this in a production system with a wp_posts table with over 450k rows and reduced query times by two orders of magnitude. Database CPU burn is down by 90% and context switches have been drastically reduced.
    66
    7 This is anecdotal, of course, but here's what this patch did for our DB master:
    8 
    9 [[Image(http://cl.ly/2j3a2a161m2131351j1w/Image_2011-08-27_at_9.15.23_PM.png)]]
    10 
    117This should be of some benefit even in small cases, since smaller datasets will result in faster sorts. The overhead of the second query is minimal. In large cases, the performance benefits range from "good" to "dramatic".
    128