ssbc / ssb-db2

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

update ssb-fixtures to 4.0.1 #416

Closed staltz closed 1 year ago

github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 540.99ms
Validate 5000 messages 582.19ms
Native to db format 5000 messages 143.10ms
Db to native format 5000 messages 101.06ms
Add 1000 elements 522.43ms
Add 1000 box1 msgs 1150.29ms
Unbox 1000 box1 msgs first run 282.67ms
Unbox 1000 box1 msgs second run 128.47ms
Add 1000 box1 msgs 1206.77ms
Query 1000 msgs first run 50.43ms
Query 1000 msgs second run 29.61ms
Add 1000 box2 msgs 1584.77ms
Unbox 1000 box2 msgs first run 436.56ms
Unbox 1000 box2 msgs second run 225.30ms
Migrate (+db1) 15126.73ms
Migrate (alone) 5117.35ms
Migrate (+db1 +db2) 11252.28ms
Migrate (+db2) 7774.25ms
Migrate continuation (+db2) 1067.99ms
Memory usage without indexes 764.00 MB = 37.96 MB + etc
Initial indexing 1978.63ms
Initial indexing maxcpu=86 6215.60ms
Initial indexing compat 1183.32ms
Two indexes updating concurrently 3708.00ms
Key one initial 60.92ms
Key two 0.69ms
Key one again 1.20ms
Reboot and key one again 60.49ms
Latest root posts 2172.37ms
Latest posts 11.81ms
Votes one initial 1775.59ms
Votes again 0.72ms
HasRoot 1560.63ms
HasRoot again 0.37ms
Author one posts 1678.39ms
Author two posts 26.04ms
Dedicated author one posts 1745.41ms
Dedicated author one posts again 0.61ms
DeleteFeed 7654.02ms
Maximum memory usage 1015.10 MB = 56.90 MB + etc
Indexes folder size 10.01mb
github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 365.68ms
Validate 5000 messages 476.03ms
Native to db format 5000 messages 106.33ms
Db to native format 5000 messages 82.58ms
Add 1000 elements 367.91ms
Add 1000 box1 msgs 999.85ms
Unbox 1000 box1 msgs first run 219.95ms
Unbox 1000 box1 msgs second run 110.99ms
Add 1000 box1 msgs 962.55ms
Query 1000 msgs first run 41.68ms
Query 1000 msgs second run 15.80ms
Add 1000 box2 msgs 1276.39ms
Unbox 1000 box2 msgs first run 282.36ms
Unbox 1000 box2 msgs second run 135.22ms
Migrate (+db1) 10622.63ms
Migrate (alone) 3483.15ms
Migrate (+db1 +db2) 8080.45ms
Migrate (+db2) 5538.06ms
Migrate continuation (+db2) 887.98ms
Memory usage without indexes 755.54 MB = 37.18 MB + etc
Initial indexing 1540.17ms
Initial indexing maxcpu=86 4629.63ms
Initial indexing compat 685.57ms
Two indexes updating concurrently 2741.95ms
Key one initial 56.82ms
Key two 0.39ms
Key one again 0.42ms
Reboot and key one again 46.98ms
Latest root posts 1658.90ms
Latest posts 7.88ms
Votes one initial 1441.93ms
Votes again 0.49ms
HasRoot 1274.70ms
HasRoot again 0.28ms
Author one posts 1355.36ms
Author two posts 14.60ms
Dedicated author one posts 1385.95ms
Dedicated author one posts again 0.48ms
DeleteFeed 4905.95ms
Maximum memory usage 1003.42 MB = 61.90 MB + etc
Indexes folder size 10.01mb