ssbc / ssb-db2

A new database for secure-scuttlebutt
47 stars 8 forks source link

refactor keys index getSeq() #338

Closed staltz closed 2 years ago

staltz commented 2 years ago

Just a cosmetic refactor to avoid duplicates of parseInt(seqStr, 10)

github-actions[bot] commented 2 years ago

Benchmark results

Part Duration
add 1000 elements 499ms
add 1000 private box1 elements 1198ms
unbox 1000 private box1 elements first run 138ms
unbox 1000 private box1 elements second run 90ms
add 1000 private box1 elements 1214ms
query 1000 elements first run 35ms
query 1000 elements second run 15ms
add 1000 private box2 elements 746ms
unbox 1000 private box2 elements first run 384ms
unbox 1000 private box2 elements second run 334ms
Migrate (+db1) 12996ms
Migrate (alone) 4593ms
Migrate (+db1 +db2) 8828ms
Migrate (+db2) 6914ms
Migrate continuation (+db2) 1050ms
Memory usage without indexes 723.75 MB = 30.25 MB + etc
Initial indexing 631ms
Initial indexing maxCpu=86 4449ms
Initial indexing compat 836ms
Two indexes updating concurrently 849ms
key one initial 51ms
key two 3ms
key one again 1ms
reboot and key one again 51ms
latest root posts 643ms
latest posts 16ms
votes one initial 533ms
votes again 1ms
hasRoot 355ms
hasRoot again 0ms
author one posts 348ms
author two posts 16ms
dedicated author one posts 343ms
dedicated author one posts again 0ms
Maximum memory usage 819.29 MB = 51.98 MB + etc
Indexes folder size 9.97mb
github-actions[bot] commented 2 years ago

Benchmark results

Part Duration
add 1000 elements 491ms
add 1000 private box1 elements 1153ms
unbox 1000 private box1 elements first run 119ms
unbox 1000 private box1 elements second run 81ms
add 1000 private box1 elements 1146ms
query 1000 elements first run 39ms
query 1000 elements second run 15ms
add 1000 private box2 elements 645ms
unbox 1000 private box2 elements first run 352ms
unbox 1000 private box2 elements second run 339ms
Migrate (+db1) 11772ms
Migrate (alone) 3858ms
Migrate (+db1 +db2) 8068ms
Migrate (+db2) 6149ms
Migrate continuation (+db2) 1034ms
Memory usage without indexes 756.36 MB = 26.86 MB + etc
Initial indexing 596ms
Initial indexing maxCpu=86 4096ms
Initial indexing compat 736ms
Two indexes updating concurrently 770ms
key one initial 50ms
key two 2ms
key one again 1ms
reboot and key one again 49ms
latest root posts 540ms
latest posts 31ms
votes one initial 479ms
votes again 0ms
hasRoot 328ms
hasRoot again 0ms
author one posts 268ms
author two posts 15ms
dedicated author one posts 275ms
dedicated author one posts again 0ms
Maximum memory usage 814.93 MB = 49.11 MB + etc
Indexes folder size 9.97mb