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!