Move docs into their own subdirectory

[onak.git] / doc / PERFORMANCE

diff --git a/doc/PERFORMANCE b/doc/PERFORMANCE
new file mode 100644 (file)
index 0000000..a889b1c
--- /dev/null
+++ b/doc/PERFORMANCE
@@ -0,0 +1,73 @@
+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