[CalendarServer-changes] [6090] CalendarServer/trunk/contrib/performance/mkcal.py

[source_changes at macosforge.org]

Revision: 6090
          http://trac.macosforge.org/projects/calendarserver/changeset/6090
Author:   exarkun at twistedmatrix.com
Date:     2010-08-16 17:44:00 -0700 (Mon, 16 Aug 2010)
Log Message:
-----------
Keep the SQL for iternext, and also report some of the SQL stats in an ad-hoc semi-useless way

Modified Paths:
--------------
    CalendarServer/trunk/contrib/performance/mkcal.py

Modified: CalendarServer/trunk/contrib/performance/mkcal.py
===================================================================
--- CalendarServer/trunk/contrib/performance/mkcal.py	2010-08-16 23:59:43 UTC (rev 6089)
+++ CalendarServer/trunk/contrib/performance/mkcal.py	2010-08-17 00:44:00 UTC (rev 6090)
@@ -215,8 +215,14 @@
 
 class SQLDuration(_Statistic):
     def summarize(self, data):
-        data = [interval for (sql, interval) in data]
-        return _Statistic.summarize(self, data)
+        statements = {}
+        intervals = []
+        for (sql, interval) in data:
+            intervals.append(interval)
+            statements[sql] = statements.get(sql, 0) + 1
+        for statement, count in statements.iteritems():
+            print count, ':', statement.replace('\n', ' ')
+        return _Statistic.summarize(self, intervals)
 
 
 class Bytes(_Statistic):
@@ -280,8 +286,8 @@
                         accum = self._iternext
 
                     accum.append((self.sql, diff))
-                    self.start = None
-                    self.sql = None
+                self.start = None
+
     _op_ITERNEXT = _op_EXECUTE
 
     def _op_B_READ(self, cmd, rest):
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macosforge.org/pipermail/calendarserver-changes/attachments/20100816/1d929612/attachment.html>