1 Performance of adding 2M key chunks (~ 1700 keys).
3 Originally ~ 30 mins with 0.0.2.
5 After adding an index on keyid for onak_keys:
6 Command being timed: "/u2/noodles/onak-0.0.3/onak"
7 User time (seconds): 75.12
8 System time (seconds): 76.08
9 Percent of CPU this job got: 3%
10 Elapsed (wall clock) time (h:mm:ss or m:ss): 1:18:17
11 Major (requiring I/O) page faults: 630
12 Minor (reclaiming a frame) page faults: 1238
14 Making deletion in the same transaction as readding:
15 Command being timed: "/u2/noodles/onak-0.0.3/onak"
16 User time (seconds): 67.28
17 System time (seconds): 75.74
18 Percent of CPU this job got: 2%
19 Elapsed (wall clock) time (h:mm:ss or m:ss): 1:22:08
20 Major (requiring I/O) page faults: 617
21 Minor (reclaiming a frame) page faults: 1241
23 Making merge_keys all one transaction:
24 Command being timed: "/u2/noodles/onak-0.0.3/onak"
25 User time (seconds): 74.45
26 System time (seconds): 69.82
27 Percent of CPU this job got: 2%
28 Elapsed (wall clock) time (h:mm:ss or m:ss): 1:29:28
29 Major (requiring I/O) page faults: 610
30 Minor (reclaiming a frame) page faults: 1237
32 Only delete old key if we know it exists:
33 Command being timed: "/u2/noodles/onak-0.0.3/onak"
34 User time (seconds): 77.47
35 System time (seconds): 75.06
36 Percent of CPU this job got: 3%
37 Elapsed (wall clock) time (h:mm:ss or m:ss): 1:16:41
38 Major (requiring I/O) page faults: 610
39 Minor (reclaiming a frame) page faults: 1239
41 onak 0.0.4ish with db3 backend; only 1203 keys:
42 Command being timed: "./onak -b add"
43 User time (seconds): 0.88
44 System time (seconds): 0.21
45 Percent of CPU this job got: 80%
46 Elapsed (wall clock) time (h:mm:ss or m:ss): 0:01.36
47 Major (requiring I/O) page faults: 198
48 Minor (reclaiming a frame) page faults: 5443
55 List of key ids in path:
56 0x651E4299 0x2213E772 0x1EB2DE66 0x87CD3DBD 0xC02440B8 0xEA1572F1 0xF5C75256 0x6
57 8FD549F 0x5B430367 0x8C90A57F 0x316C50AE 0x56ABD303 0x641B6747 0x6B5A209A