Mercurial Hosting > traffic-intelligence
view 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 source
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!