summaryrefslogtreecommitdiff
path: root/openerp/sql_db.py
diff options
context:
space:
mode:
authorOlivier Dony <odo@openerp.com>2016-03-08 11:19:06 +0100
committerOlivier Dony <odo@openerp.com>2016-03-08 16:45:48 +0100
commitc4429aa4993a8a38680ddf20f67d1b7797a7f171 (patch)
tree5efce5bc9f5bcebfc0ba2802962151dafcbafcc2 /openerp/sql_db.py
parent1a58e1085edfddde0c0be2b6d76cbf674b61fa4f (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.py7
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: