search

ssbc / jitdb

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

Don't use default values for sortBy #194

Closed arj03 closed 2 years ago

arj03 commented 2 years ago

This is a breaking change. An update to https://github.com/ssb-ngi-pointer/jitdb/pull/193. Needs a PR for ssb-db2. I can work on that after this.

See https://github.com/ssb-ngi-pointer/jitdb/pull/193#discussion_r825668199

github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.57ms ± 0.36ms -9.3 kB ± 19.39 kB 41
Create an index twice concurrently 592.32ms ± 4.42ms -1.96 kB ± 66.38 kB 93
Load core indexes 1.28ms ± 0.02ms 96.64 B ± 225.45 B 7085
Load two indexes concurrently 645.7ms ± 20.55ms 66.2 kB ± 163.46 kB 18
Paginate 10 results 30.52ms ± 1.13ms 4.22 kB ± 63.84 kB 23
Paginate 20000 msgs with pageSize=5 6275.46ms ± 106.97ms -33.69 kB ± 3611.04 kB 5
Paginate 20000 msgs with pageSize=500 558.32ms ± 9.69ms -323.86 kB ± 876.14 kB 20
Query 1 big index (1st run) 815.39ms ± 8.71ms 35.28 kB ± 69.68 kB 67
Query 1 big index (2nd run) 299.15ms ± 3.18ms 2.53 kB ± 37.06 kB 44
Query 3 indexes (1st run) 1070.24ms ± 14.25ms -122.5 kB ± 103.91 kB 50
Query 3 indexes (2nd run) 225.82ms ± 2.35ms 3.47 kB ± 197.96 kB 51
Query a prefix map (1st run) 242.15ms ± 2.83ms -523 B ± 477331.59 B 24
Query a prefix map (2nd run) 10.59ms ± 0.66ms -1.48 kB ± 11.16 kB 24
github-actions[bot] commented 2 years ago

Benchmark results

Part Speed Heap Change Samples
Count 1 big index (3rd run) 0.54ms ± 0.27ms 19.4 kB ± 17.62 kB 49
Create an index twice concurrently 605.12ms ± 10.17ms -31.4 kB ± 66.52 kB 91
Load core indexes 0.85ms ± 0.01ms 86.6 B ± 180.43 B 9151
Load two indexes concurrently 697.61ms ± 32.54ms 109.59 kB ± 256.08 kB 17
Paginate 10 results 23.65ms ± 0.68ms -1.72 kB ± 12.26 kB 27
Paginate 20000 msgs with pageSize=5 6109.46ms ± 95.61ms -2.48 MB ± 1.76 MB 5
Paginate 20000 msgs with pageSize=500 616.04ms ± 6.78ms 332.23 kB ± 930.66 kB 19
Query 1 big index (1st run) 837.39ms ± 9.1ms 1.2 kB ± 71.59 kB 65
Query 1 big index (2nd run) 319.92ms ± 5.7ms 60.86 kB ± 54.98 kB 41
Query 3 indexes (1st run) 849.19ms ± 21.86ms -35.53 kB ± 108.94 kB 65
Query 3 indexes (2nd run) 220.75ms ± 1.76ms 79.14 kB ± 53.76 kB 52
Query a prefix map (1st run) 256.22ms ± 5.87ms 46.49 kB ± 181.92 kB 23
Query a prefix map (2nd run) 10.48ms ± 0.49ms -9.05 kB ± 15.57 kB 24