Mercurial Hosting > traffic-intelligence
diff python/storage.py @ 712:21aeadcfbabb
added script to test SQLite performance and impact of indices
| author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
|---|---|
| date | Thu, 23 Jul 2015 01:13:32 -0400 |
| parents | 523eda2fafd4 |
| children | d6c69d3d09e5 |
line wrap: on
line diff
--- a/python/storage.py Wed Jul 22 17:54:33 2015 -0400 +++ b/python/storage.py Thu Jul 23 01:13:32 2015 -0400 @@ -338,7 +338,7 @@ queryStatement = 'SELECT OF.object_id, P.frame_number, avg(P.x_coordinate), avg(P.y_coordinate) from '+tableName+' P, objects_features OF where P.trajectory_id = OF.trajectory_id' if objectNumbers is not None: queryStatement += ' and OF.object_id '+objectCriteria - queryStatement += ' group by OF.object_id, P.frame_number ORDER BY OF.object_id, P.frame_number' + queryStatement += ' GROUP BY OF.object_id, P.frame_number ORDER BY OF.object_id, P.frame_number' cursor.execute(queryStatement) logging.debug(queryStatement) elif trajectoryType in ['bbtop', 'bbbottom']: @@ -348,7 +348,7 @@ corner = 'bottom_right' queryStatement = 'SELECT object_id, frame_number, x_'+corner+', y_'+corner+' FROM '+tableName if objectNumbers is not None: - queryStatement += ' where object_id '+objectCriteria + queryStatement += ' WHERE object_id '+objectCriteria queryStatement += ' ORDER BY object_id, frame_number' cursor.execute(queryStatement) logging.debug(queryStatement)