Mercurial Hosting > traffic-intelligence
annotate samples/performances.txt @ 744:ed6ff2ec0aeb dev
bug correction from Laurent Gauthier
author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
---|---|
date | Thu, 10 Sep 2015 15:48:01 -0400 |
parents | a850a4f92735 |
children |
rev | line source |
---|---|
730
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
1 python -m timeit 'from utils import LCSS; from numpy.random import random_sample; lcss = LCSS(metric = "cityblock", epsilon = 0.1); lcss.compute(random_sample((1000,2)), random_sample((2000, 2)))' |
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
2 10 loops, best of 3: 1.6 sec per loop |
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
3 |
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
4 python -m timeit 'from utils import LCSS; from numpy.random import random_sample; lcss = LCSS(similarityFunc = lambda x,y: (abs(x[0]-y[0]) <= 0.1) and (abs(x[1]-y[1]) <= 0.1)); lcss.compute(random_sample((1000,2)), random_sample((2000, 2)))' |
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
5 10 loops, best of 3: 3.48 sec per loop |
a850a4f92735
added performance script comparing lcss using cdist with default
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
714
diff
changeset
|
6 ######## |
713
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
7 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
|
8 #### |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
9 test query positions |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
10 #### |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
11 no index |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
12 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
13 real 7m31.857s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
14 user 2m20.962s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
15 sys 5m23.521s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
16 with index on trajectory_id |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
17 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
18 real 7m43.479s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
19 user 2m25.793s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
20 sys 5m27.585s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
21 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
|
22 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
23 real 7m36.917s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
24 user 2m21.628s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
25 sys 5m26.639s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
26 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
|
27 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
28 real 7m28.447s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
29 user 2m15.028s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
30 sys 5m26.697s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
31 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
|
32 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
33 real 0m16.219s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
34 user 0m15.988s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
35 sys 0m0.245s |
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 real 0m16.185s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
38 user 0m15.927s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
39 sys 0m0.272s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
40 #### |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
41 test query object positions |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
42 #### |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
43 no index |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
44 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
45 real 0m22.119s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
46 user 0m20.147s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
47 sys 0m1.406s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
48 index on trajectory_id |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
49 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
50 real 0m21.850s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
51 user 0m19.834s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
52 sys 0m1.401s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
53 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
|
54 |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
55 real 0m25.066s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
56 user 0m23.315s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
57 sys 0m1.265s |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
58 Cleaning up! |
b0cb644950aa
added results on one of Norway db
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
diff
changeset
|
59 |
714
d6c69d3d09e5
developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
713
diff
changeset
|
60 ############################## |
d6c69d3d09e5
developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
713
diff
changeset
|
61 indexed: positions et velocities on trajectory_id |
d6c69d3d09e5
developing python performance tests for SQLite
Nicolas Saunier <nicolas.saunier@polymtl.ca>
parents:
713
diff
changeset
|
62 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
|
63 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
|
64 feature-based-tracking ~/Research/Data/nyc/125th-hancock/tracking-125.cfg 20246.41s user 25.64s system 99% cpu 5:38:38.87 total |