Mercurial Hosting > traffic-intelligence

changeset 713:b0cb644950aa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added results on one of Norway db
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 23 Jul 2015 09:31:47 -0400
parents 21aeadcfbabb
children d6c69d3d09e5
files samples/performances.txt scripts/performance.sh
diffstat 2 files changed, 54 insertions(+), 1 deletions(-) [+]
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!
+
--- a/scripts/performance.sh	Thu Jul 23 01:13:32 2015 -0400
+++ b/scripts/performance.sh	Thu Jul 23 09:31:47 2015 -0400
@@ -79,5 +79,5 @@
 
 ###
 echo "Cleaning up!"
-dropIndices
+#dropIndices
 rm $dbFilename