ssbc / ssb-db2

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

add config options for speeding up tests #422

Closed mixmix closed 1 year ago

github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 385.06ms
Validate 5000 messages 424.33ms
Native to db format 5000 messages 107.99ms
Db to native format 5000 messages 95.26ms
Add 1000 elements 361.34ms
Add 1000 box1 msgs 930.68ms
Unbox 1000 box1 msgs first run 179.03ms
Unbox 1000 box1 msgs second run 85.98ms
Add 1000 box1 msgs 865.16ms
Query 1000 msgs first run 38.09ms
Query 1000 msgs second run 10.66ms
Add 1000 box2 msgs 1303.13ms
Unbox 1000 box2 msgs first run 394.23ms
Unbox 1000 box2 msgs second run 172.86ms
Migrate (+db1) 11205.87ms
Migrate (alone) 3716.82ms
Migrate (+db1 +db2) 7845.09ms
Migrate (+db2) 5708.20ms
Migrate continuation (+db2) 1107.77ms
Memory usage without indexes 759.50 MB = 40.03 MB + etc
Initial indexing 1438.79ms
Initial indexing maxcpu=86 4276.91ms
Initial indexing compat 635.87ms
Two indexes updating concurrently 2606.81ms
Key one initial 79.76ms
Key two 0.63ms
Key one again 1.74ms
Reboot and key one again 72.71ms
Latest root posts 1599.24ms
Latest posts 8.75ms
Votes one initial 1296.73ms
Votes again 0.34ms
HasRoot 1135.64ms
HasRoot again 0.60ms
Author one posts 1241.29ms
Author two posts 16.00ms
Dedicated author one posts 1225.44ms
Dedicated author one posts again 0.61ms
DeleteFeed 5281.92ms
Maximum memory usage 842.54 MB = 62.02 MB + etc
Indexes folder size 10.01mb