Performance of adding 2M key chunks (~ 1700 keys). Originally ~ 30 mins with 0.0.2. After adding an index on keyid for onak_keys: Command being timed: "/u2/noodles/onak-0.0.3/onak" User time (seconds): 75.12 System time (seconds): 76.08 Percent of CPU this job got: 3% Elapsed (wall clock) time (h:mm:ss or m:ss): 1:18:17 Major (requiring I/O) page faults: 630 Minor (reclaiming a frame) page faults: 1238 Making deletion in the same transaction as readding: Command being timed: "/u2/noodles/onak-0.0.3/onak" User time (seconds): 67.28 System time (seconds): 75.74 Percent of CPU this job got: 2% Elapsed (wall clock) time (h:mm:ss or m:ss): 1:22:08 Major (requiring I/O) page faults: 617 Minor (reclaiming a frame) page faults: 1241 Making merge_keys all one transaction: Command being timed: "/u2/noodles/onak-0.0.3/onak" User time (seconds): 74.45 System time (seconds): 69.82 Percent of CPU this job got: 2% Elapsed (wall clock) time (h:mm:ss or m:ss): 1:29:28 Major (requiring I/O) page faults: 610 Minor (reclaiming a frame) page faults: 1237 Only delete old key if we know it exists: Command being timed: "/u2/noodles/onak-0.0.3/onak" User time (seconds): 77.47 System time (seconds): 75.06 Percent of CPU this job got: 3% Elapsed (wall clock) time (h:mm:ss or m:ss): 1:16:41 Major (requiring I/O) page faults: 610 Minor (reclaiming a frame) page faults: 1239 onak 0.0.4ish with db3 backend; only 1203 keys: Command being timed: "./onak -b add" User time (seconds): 0.88 System time (seconds): 0.21 Percent of CPU this job got: 80% Elapsed (wall clock) time (h:mm:ss or m:ss): 0:01.36 Major (requiring I/O) page faults: 198 Minor (reclaiming a frame) page faults: 5443 maxpath: Orig: List of key ids in path: 0x651E4299 0x2213E772 0x1EB2DE66 0x87CD3DBD 0xC02440B8 0xEA1572F1 0xF5C75256 0x6 8FD549F 0x5B430367 0x8C90A57F 0x316C50AE 0x56ABD303 0x641B6747 0x6B5A209A real 5m58.355s user 0m11.110s sys 0m0.440s After DISTINCT: real 5m59.231s user 0m9.630s sys 0m0.410s With DB3 backend: real 0m15.917s user 0m15.620s sys 0m0.310s