Mercurial Hosting > traffic-intelligence
comparison 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 |
comparison
equal
deleted
inserted
replaced
712:21aeadcfbabb | 713:b0cb644950aa |
---|---|
1 Performance report using ../../Data/norway/2_video/20130606-0830.sqlite | |
2 #### | |
3 test query positions | |
4 #### | |
5 no index | |
6 | |
7 real 7m31.857s | |
8 user 2m20.962s | |
9 sys 5m23.521s | |
10 with index on trajectory_id | |
11 | |
12 real 7m43.479s | |
13 user 2m25.793s | |
14 sys 5m27.585s | |
15 with index on trajectory_id and frame_number | |
16 | |
17 real 7m36.917s | |
18 user 2m21.628s | |
19 sys 5m26.639s | |
20 with index on the 2 columns trajectory_id | |
21 | |
22 real 7m28.447s | |
23 user 2m15.028s | |
24 sys 5m26.697s | |
25 query all feature positions, order by id and frame_number (index/no index) | |
26 | |
27 real 0m16.219s | |
28 user 0m15.988s | |
29 sys 0m0.245s | |
30 | |
31 real 0m16.185s | |
32 user 0m15.927s | |
33 sys 0m0.272s | |
34 #### | |
35 test query object positions | |
36 #### | |
37 no index | |
38 | |
39 real 0m22.119s | |
40 user 0m20.147s | |
41 sys 0m1.406s | |
42 index on trajectory_id | |
43 | |
44 real 0m21.850s | |
45 user 0m19.834s | |
46 sys 0m1.401s | |
47 index on trajectory_id in positions and objects_features | |
48 | |
49 real 0m25.066s | |
50 user 0m23.315s | |
51 sys 0m1.265s | |
52 Cleaning up! | |
53 |