Mercurial Hosting > traffic-intelligence
diff samples/performances.txt @ 713:b0cb644950aa
added results on one of Norway db
author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
---|---|
date | Thu, 23 Jul 2015 09:31:47 -0400 |
parents | |
children | d6c69d3d09e5 |
line wrap: on
line diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/samples/performances.txt Thu Jul 23 09:31:47 2015 -0400 @@ -0,0 +1,53 @@ +Performance report using ../../Data/norway/2_video/20130606-0830.sqlite +#### +test query positions +#### +no index + +real 7m31.857s +user 2m20.962s +sys 5m23.521s +with index on trajectory_id + +real 7m43.479s +user 2m25.793s +sys 5m27.585s +with index on trajectory_id and frame_number + +real 7m36.917s +user 2m21.628s +sys 5m26.639s +with index on the 2 columns trajectory_id + +real 7m28.447s +user 2m15.028s +sys 5m26.697s +query all feature positions, order by id and frame_number (index/no index) + +real 0m16.219s +user 0m15.988s +sys 0m0.245s + +real 0m16.185s +user 0m15.927s +sys 0m0.272s +#### +test query object positions +#### +no index + +real 0m22.119s +user 0m20.147s +sys 0m1.406s +index on trajectory_id + +real 0m21.850s +user 0m19.834s +sys 0m1.401s +index on trajectory_id in positions and objects_features + +real 0m25.066s +user 0m23.315s +sys 0m1.265s +Cleaning up! +