Mercurial Hosting > traffic-intelligence

annotate samples/performances.txt @ 714:d6c69d3d09e5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
developing python performance tests for SQLite
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Fri, 24 Jul 2015 17:58:59 -0400
parents b0cb644950aa
children a850a4f92735
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
713
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
1 Performance report using ../../Data/norway/2_video/20130606-0830.sqlite
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
2 ####
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
3 test query positions
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
4 ####
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
5 no index
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
6
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
7 real 7m31.857s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
8 user 2m20.962s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
9 sys 5m23.521s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
10 with index on trajectory_id
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
11
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
12 real 7m43.479s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
13 user 2m25.793s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
14 sys 5m27.585s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
15 with index on trajectory_id and frame_number
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
16
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
17 real 7m36.917s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
18 user 2m21.628s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
19 sys 5m26.639s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
20 with index on the 2 columns trajectory_id
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
21
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
22 real 7m28.447s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
23 user 2m15.028s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
24 sys 5m26.697s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
25 query all feature positions, order by id and frame_number (index/no index)
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
26
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
27 real 0m16.219s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
28 user 0m15.988s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
29 sys 0m0.245s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
30
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
31 real 0m16.185s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
32 user 0m15.927s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
33 sys 0m0.272s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
34 ####
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
35 test query object positions
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
36 ####
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
37 no index
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
38
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
39 real 0m22.119s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
40 user 0m20.147s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
41 sys 0m1.406s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
42 index on trajectory_id
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
43
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
44 real 0m21.850s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
45 user 0m19.834s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
46 sys 0m1.401s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
47 index on trajectory_id in positions and objects_features
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
48
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
49 real 0m25.066s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
50 user 0m23.315s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
51 sys 0m1.265s
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
52 Cleaning up!
b0cb644950aa added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff changeset
53
714
d6c69d3d09e5 developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents: 713
diff changeset
54 ##############################
d6c69d3d09e5 developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents: 713
diff changeset
55 indexed: positions et velocities on trajectory_id
d6c69d3d09e5 developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents: 713
diff changeset
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
d6c69d3d09e5 developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents: 713
diff changeset
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
d6c69d3d09e5 developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents: 713
diff changeset
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