diff options
| author | Olivier Dony <odo@openerp.com> | 2016-03-08 11:19:06 +0100 |
|---|---|---|
| committer | Olivier Dony <odo@openerp.com> | 2016-03-08 16:45:48 +0100 |
| commit | c4429aa4993a8a38680ddf20f67d1b7797a7f171 (patch) | |
| tree | 5efce5bc9f5bcebfc0ba2802962151dafcbafcc2 /openerp/sql_db.py | |
| parent | 1a58e1085edfddde0c0be2b6d76cbf674b61fa4f (diff) | |
[IMP] sql_db: use time.time() for timing query execution
Minor improvement: subtracting time.time() floats is about
10x faster than creating `timedelta` objects, and the code
is simpler.
Diffstat (limited to 'openerp/sql_db.py')
| -rw-r--r-- | openerp/sql_db.py | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/openerp/sql_db.py b/openerp/sql_db.py index c59c78d1a18..dd4d2af806a 100644 --- a/openerp/sql_db.py +++ b/openerp/sql_db.py @@ -11,6 +11,7 @@ the ORM does, in fact. from contextlib import contextmanager from functools import wraps import logging +import time import urlparse import uuid @@ -47,7 +48,6 @@ psycopg2.extensions.register_type(psycopg2.extensions.new_type((700, 701, 1700,) import tools from tools.func import frame_codeinfo -from datetime import datetime as mdt from datetime import timedelta import threading from inspect import currentframe @@ -213,7 +213,7 @@ class Cursor(object): raise ValueError("SQL query parameters should be a tuple, list or dict; got %r" % (params,)) if self.sql_log: - now = mdt.now() + now = time.time() _logger.debug("query: %s", query) try: @@ -233,8 +233,7 @@ class Cursor(object): # advanced stats only if sql_log is enabled if self.sql_log: - delay = mdt.now() - now - delay = delay.seconds * 1E6 + delay.microseconds + delay = (time.time() - now) * 1E6 res_from = re_from.match(query.lower()) if res_from: |
