search

ssbc / jitdb

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

fix seekers in test/helpers #211

Closed staltz closed 2 years ago

staltz commented 2 years ago

For issue #210. Doesn't affect code in production because it's just test/helpers.js but in ssb-db2 we have real seekers used in production. PR for that coming later.

github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.35ms ± 0.03ms -7.23 kB ± 15.02 kB 58
Create an index twice concurrently 500.29ms ± 2.74ms 21.51 kB ± 26.96 kB 109
Load core indexes 0.87ms ± 0.01ms 86.52 B ± 182.55 B 9126
Load two indexes concurrently 441.86ms ± 4.6ms 6.06 kB ± 185.36 kB 23
Paginate 10 results 25.57ms ± 0.83ms 2.06 kB ± 13.86 kB 29
Paginate 20000 msgs with pageSize=5 5672.88ms ± 16.37ms 1.87 MB ± 1.75 MB 5
Paginate 20000 msgs with pageSize=500 506.79ms ± 2.86ms -128.38 kB ± 537.53 kB 22
Query 1 big index (1st run) 844.72ms ± 9.27ms 74.09 B ± 52568.42 B 65
Query 1 big index (2nd run) 333.29ms ± 4.06ms 23.75 kB ± 11.99 kB 42
Query 3 indexes (1st run) 802.48ms ± 10.64ms -75.38 kB ± 87.81 kB 68
Query 3 indexes (2nd run) 267.3ms ± 1.91ms -22.51 kB ± 64 kB 51
Query a prefix map (1st run) 232.05ms ± 2.11ms -28.96 kB ± 533.53 kB 25
Query a prefix map (2nd run) 13.68ms ± 0.64ms -2.23 kB ± 43.37 kB 25
github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.76ms ± 0.42ms -7.45 kB ± 17.36 kB 48
Create an index twice concurrently 498.05ms ± 4.28ms -155.42 B ± 35178.23 B 110
Load core indexes 0.83ms ± 0.01ms 90.46 B ± 177.93 B 9545
Load two indexes concurrently 562.55ms ± 10.25ms 31.93 kB ± 136.85 kB 19
Paginate 10 results 29.58ms ± 1.23ms 11.65 kB ± 19.8 kB 27
Paginate 20000 msgs with pageSize=5 6252.41ms ± 140.16ms 2.2 MB ± 2 MB 5
Paginate 20000 msgs with pageSize=500 716.25ms ± 20.84ms 320.24 kB ± 687.33 kB 18
Query 1 big index (1st run) 875.52ms ± 10.51ms 18.76 kB ± 33.99 kB 62
Query 1 big index (2nd run) 267.44ms ± 1.91ms -8.63 kB ± 9.12 kB 57
Query 3 indexes (1st run) 766.95ms ± 9.74ms -10.86 kB ± 79.78 kB 72
Query 3 indexes (2nd run) 223.11ms ± 1.66ms -20.63 kB ± 30.38 kB 62
Query a prefix map (1st run) 219.43ms ± 6.87ms -12.39 kB ± 639.76 kB 26
Query a prefix map (2nd run) 13.88ms ± 0.48ms -9.52 kB ± 61.62 kB 25