Mercurial Hosting > traffic-intelligence

annotate samples/performances.txt @ 1250:77fbd0e2ba7d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
dltrack works with moving average filtering
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 15 Feb 2024 22:04:35 -0500
parents a850a4f92735
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
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