Context Navigation

Changes between Initial Version and Version 19 of Ticket #18536

Timestamp:: 12/19/2011 03:17:26 PM (13 years ago)
Author:: nacin
Comment:: Removing the screenshot (dead link). I do remember the graph looking mighty impressive, though.

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

-                      initial
+                      v19
 I 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.
-This is anecdotal, of course, but here's what this patch did for our DB master:
-[[Image(http://cl.ly/2j3a2a161m2131351j1w/Image_2011-08-27_at_9.15.23_PM.png)]]
 This 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".