ssbc / jitdb

A database on top of a log with automatic index generation and maintenance
50 stars 7 forks source link

Seekkey2 #218

Closed arj03 closed 2 years ago

arj03 commented 2 years ago

See https://github.com/ssbc/bipf/pull/33

github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.53ms ± 0.26ms 7.61 kB ± 17.11 kB 58
Create an index twice concurrently 598.36ms ± 4.01ms 10.91 kB ± 26.98 kB 91
Load core indexes 0.9ms ± 0.01ms 84.83 B ± 193.86 B 8897
Load two indexes concurrently 417.31ms ± 2.35ms -87.15 kB ± 108.06 kB 23
Paginate 10 results 32.49ms ± 1.97ms 1.08 kB ± 27.03 kB 27
Paginate 20000 msgs with pageSize=5 6104.77ms ± 44.03ms 2.81 MB ± 2.23 MB 5
Paginate 20000 msgs with pageSize=500 541.25ms ± 8.93ms 515.14 kB ± 551.5 kB 21
Query 1 big index (1st run) 990.48ms ± 12.03ms -29.8 kB ± 57.08 kB 54
Query 1 big index (2nd run) 251.06ms ± 0.6ms -2.57 kB ± 9.29 kB 60
Query 3 indexes (1st run) 923.62ms ± 10.95ms -68.74 kB ± 108.36 kB 59
Query 3 indexes (2nd run) 249.33ms ± 2.23ms 120.39 kB ± 50.34 kB 54
Query a prefix map (1st run) 273.55ms ± 3ms -308.17 kB ± 635.61 kB 23
Query a prefix map (2nd run) 10.25ms ± 0.49ms 46.13 kB ± 32.94 kB 26
github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.45ms ± 0.09ms -360.68 B ± 22005.2 B 47
Create an index twice concurrently 637.16ms ± 4.37ms 19.4 kB ± 32.06 kB 85
Load core indexes 0.9ms ± 0.01ms 84.9 B ± 191 B 9093
Load two indexes concurrently 524.59ms ± 6ms 73.64 kB ± 90.84 kB 20
Paginate 10 results 24.96ms ± 1.08ms 8.23 kB ± 19.3 kB 30
Paginate 20000 msgs with pageSize=5 6073.85ms ± 32.28ms 2.78 MB ± 2.59 MB 5
Paginate 20000 msgs with pageSize=500 468.46ms ± 3.31ms -287.49 kB ± 454.56 kB 23
Query 1 big index (1st run) 894.31ms ± 8.63ms 28.04 kB ± 47.93 kB 61
Query 1 big index (2nd run) 237.1ms ± 2.61ms 4.35 kB ± 11.66 kB 63
Query 3 indexes (1st run) 744.05ms ± 7.55ms -94.14 kB ± 86.34 kB 74
Query 3 indexes (2nd run) 221.32ms ± 2.05ms 13.83 kB ± 24.44 kB 61
Query a prefix map (1st run) 270.54ms ± 1.97ms 303.5 kB ± 572.8 kB 23
Query a prefix map (2nd run) 12.19ms ± 0.6ms 32.26 kB ± 29.04 kB 23