Changeset 2742 for pykota/trunk/pykota/storages

Timestamp:

02/21/06 19:42:25 (18 years ago)

Author:

jerome

Message:

Now ouputs some timing info even when debug:no is used.
Also uses psyco, which halves the time spent before deletion begins.
The storagecaching:yes directive is not at fault.

Files:

• pykota/trunk/pykota/storages/sql.py (modified) (1 diff)

pykota/trunk/pykota/storages/sql.py

@@ -467 +467 @@
         users = {}
         upquotas = {}
+        import time
+        before = time.time()
         result = self.doSearch("SELECT users.id AS uid, users.description AS udesc, printers.id AS pid, printers.description AS pdesc, printers.maxjobsize AS pmaxjobsize, userpquota.id AS upqid, userpquota.maxjobsize AS upqmaxjobsize, users.*, printers.*, userpquota.* FROM users, printers, userpquota WHERE users.id=userpquota.userid AND printers.id=userpquota.printerid;")
+        after = time.time()
+        self.tool.printInfo("SELECT took %.4f seconds." % (after - before))
         if result :
             for record in result :