Mercurial Hosting > traffic-intelligence
comparison samples/performances.txt @ 715:a05f79c74d6d dev
merged default with dev
| author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
|---|---|
| date | Sat, 25 Jul 2015 22:36:39 -0400 |
| parents | d6c69d3d09e5 |
| children | a850a4f92735 |
comparison
equal
deleted
inserted
replaced
| 709:29daabe094fe | 715:a05f79c74d6d |
|---|---|
| 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 | |
| 54 ############################## | |
| 55 indexed: positions et velocities on trajectory_id | |
| 56 time feature-based-tracking ~/Research/Data/nyc/125th-hancock/tracking-125.cfg --database-filename tmp-notindexed.sqlite --gf >> log.txt && time feature-based-tracking ~/Research/Data/nyc/125th-hancock/tracking-125.cfg --database-filename tmp.sqlite --gf >> log-notindexed.txt | |
| 57 feature-based-tracking ~/Research/Data/nyc/125th-hancock/tracking-125.cfg 19985.11s user 24.37s system 99% cpu 5:34:01.61 total | |
| 58 feature-based-tracking ~/Research/Data/nyc/125th-hancock/tracking-125.cfg 20246.41s user 25.64s system 99% cpu 5:38:38.87 total |