[CalendarServer-changes] [6621] CalendarServer/trunk/contrib/performance/fix-units.sql

[source_changes at macosforge.org]

Revision: 6621
          http://trac.macosforge.org/projects/calendarserver/changeset/6621
Author:   exarkun at twistedmatrix.com
Date:     2010-11-11 12:14:49 -0800 (Thu, 11 Nov 2010)
Log Message:
-----------
Correctly specify the units of each benchmark for codespeed

Added Paths:
-----------
    CalendarServer/trunk/contrib/performance/fix-units.sql

Added: CalendarServer/trunk/contrib/performance/fix-units.sql
===================================================================
--- CalendarServer/trunk/contrib/performance/fix-units.sql	                        (rev 0)
+++ CalendarServer/trunk/contrib/performance/fix-units.sql	2010-11-11 20:14:49 UTC (rev 6621)
@@ -0,0 +1,13 @@
+-- Set the units of all of the benchmarks to what they really are.
+
+update codespeed_benchmark set units_title = 'Statements' where name like '%-SQLcount';
+update codespeed_benchmark set units_title = 'Bytes' where name like '%-read';
+update codespeed_benchmark set units_title = 'Bytes' where name like '%-write';
+update codespeed_benchmark set units_title = 'Bytes' where name like '%-pagein';
+update codespeed_benchmark set units_title = 'Bytes' where name like '%-pageout';
+
+update codespeed_benchmark set units = 'statements' where name like '%-SQLcount';
+update codespeed_benchmark set units = 'bytes' where name like '%-read'; 
+update codespeed_benchmark set units = 'bytes' where name like '%-write';
+update codespeed_benchmark set units = 'bytes' where name like '%-pagein';
+update codespeed_benchmark set units = 'bytes' where name like '%-pageout';
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20101111/80275d06/attachment.html>