ssbc / ssb-db2

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

benchmark deleteFeed() #372

Closed staltz closed 2 years ago

staltz commented 2 years ago

I thought I was going to speed up deleteFeed() but I wanted to first make a benchmark to prove it's getting faster. Then I tried all sort of things and I realized I could only make deleteFeed() slower :cry: . But at least it's useful to add this benchmark so we know the baseline for deleteFeed.

github-actions[bot] commented 2 years ago

Benchmark results

Part Duration
add 1000 elements 500ms
add 1000 private box1 elements 1215ms
unbox 1000 private box1 elements first run 139ms
unbox 1000 private box1 elements second run 98ms
add 1000 private box1 elements 1208ms
query 1000 elements first run 38ms
query 1000 elements second run 13ms
add 1000 private box2 elements 591ms
unbox 1000 private box2 elements first run 353ms
unbox 1000 private box2 elements second run 347ms
Migrate (+db1) 11188ms
Migrate (alone) 3776ms
Migrate (+db1 +db2) 8350ms
Migrate (+db2) 6035ms
Migrate continuation (+db2) 844ms
Memory usage without indexes 731.51 MB = 34.83 MB + etc
Initial indexing 681ms
Initial indexing maxCpu=86 3986ms
Initial indexing compat 586ms
Two indexes updating concurrently 968ms
key one initial 50ms
key two 1ms
key one again 1ms
reboot and key one again 52ms
latest root posts 751ms
latest posts 10ms
votes one initial 543ms
votes again 1ms
hasRoot 383ms
hasRoot again 0ms
author one posts 488ms
author two posts 15ms
dedicated author one posts 479ms
dedicated author one posts again 1ms
deleteFeed 3050ms
Maximum memory usage 1146.50 MB = 199.48 MB + etc
Indexes folder size 9.97mb
github-actions[bot] commented 2 years ago

Benchmark results

Part Duration
add 1000 elements 484ms
add 1000 private box1 elements 1174ms
unbox 1000 private box1 elements first run 130ms
unbox 1000 private box1 elements second run 100ms
add 1000 private box1 elements 1167ms
query 1000 elements first run 46ms
query 1000 elements second run 13ms
add 1000 private box2 elements 646ms
unbox 1000 private box2 elements first run 352ms
unbox 1000 private box2 elements second run 350ms
Migrate (+db1) 12027ms
Migrate (alone) 4139ms
Migrate (+db1 +db2) 8486ms
Migrate (+db2) 6364ms
Migrate continuation (+db2) 1091ms
Memory usage without indexes 740.67 MB = 38.02 MB + etc
Initial indexing 742ms
Initial indexing maxCpu=86 4215ms
Initial indexing compat 683ms
Two indexes updating concurrently 1060ms
key one initial 57ms
key two 0ms
key one again 2ms
reboot and key one again 51ms
latest root posts 773ms
latest posts 5ms
votes one initial 566ms
votes again 1ms
hasRoot 357ms
hasRoot again 1ms
author one posts 477ms
author two posts 22ms
dedicated author one posts 485ms
dedicated author one posts again 1ms
deleteFeed 3124ms
Maximum memory usage 1150.71 MB = 205.20 MB + etc
Indexes folder size 9.97mb