search

ssbc / ssb-db2

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

Improve documentation for getStatus #392

Closed arj03 closed 1 year ago

arj03 commented 1 year ago

@mixmix can you see if this helps you describe what the function does?

github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 527.41ms
Validate 5000 messages 536.81ms
Native to db format 5000 messages 140.98ms
Db to native format 5000 messages 109.41ms
Add 1000 elements 398.83ms
Add 1000 box1 msgs 1165.95ms
Unbox 1000 box1 msgs first run 284.70ms
Unbox 1000 box1 msgs second run 138.05ms
Add 1000 box1 msgs 1163.46ms
Query 1000 msgs first run 43.17ms
Query 1000 msgs second run 26.79ms
Add 1000 box2 msgs 1700.20ms
Unbox 1000 box2 msgs first run 460.08ms
Unbox 1000 box2 msgs second run 235.89ms
Migrate (+db1) 15698.20ms
Migrate (alone) 5752.67ms
Migrate (+db1 +db2) 12030.93ms
Migrate (+db2) 8290.82ms
Migrate continuation (+db2) 1363.32ms
Memory usage without indexes 758.80 MB = 39.68 MB + etc
Initial indexing 2134.97ms
Initial indexing maxcpu=86 6325.29ms
Initial indexing compat 1114.14ms
Two indexes updating concurrently 3702.00ms
Key one initial 60.62ms
Key two 5.46ms
Key one again 1.38ms
Reboot and key one again 64.04ms
Latest root posts 2308.26ms
Latest posts 10.23ms
Votes one initial 1927.59ms
Votes again 0.65ms
HasRoot 1646.25ms
HasRoot again 0.42ms
Author one posts 1861.91ms
Author two posts 25.24ms
Dedicated author one posts 1772.43ms
Dedicated author one posts again 1.07ms
DeleteFeed 3720.97ms
Maximum memory usage 1009.75 MB = 59.07 MB + etc
Indexes folder size 10.01mb
mixmix commented 1 year ago

@arj03 can we commit the suggestions I made, or some alternative. Anything small would be better than nothing merged

mixmix commented 1 year ago

@arj03 polite bump. Lets go for easy improvements

arj03 commented 1 year ago

I'll have a look soon.

github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 342.74ms
Validate 5000 messages 460.50ms
Native to db format 5000 messages 97.41ms
Db to native format 5000 messages 97.27ms
Add 1000 elements 367.49ms
Add 1000 box1 msgs 974.33ms
Unbox 1000 box1 msgs first run 190.63ms
Unbox 1000 box1 msgs second run 92.66ms
Add 1000 box1 msgs 933.15ms
Query 1000 msgs first run 42.55ms
Query 1000 msgs second run 10.34ms
Add 1000 box2 msgs 1268.89ms
Unbox 1000 box2 msgs first run 329.94ms
Unbox 1000 box2 msgs second run 169.53ms
Migrate (+db1) 10174.56ms
Migrate (alone) 3157.91ms
Migrate (+db1 +db2) 7142.87ms
Migrate (+db2) 5021.04ms
Migrate continuation (+db2) 917.68ms
Memory usage without indexes 765.73 MB = 43.80 MB + etc
Initial indexing 1386.26ms
Initial indexing maxcpu=86 4668.01ms
Initial indexing compat 627.84ms
Two indexes updating concurrently 2446.30ms
Key one initial 71.28ms
Key two 1.01ms
Key one again 0.93ms
Reboot and key one again 67.85ms
Latest root posts 1463.55ms
Latest posts 8.62ms
Votes one initial 1245.22ms
Votes again 0.35ms
HasRoot 1130.21ms
HasRoot again 0.33ms
Author one posts 1222.38ms
Author two posts 19.05ms
Dedicated author one posts 1203.27ms
Dedicated author one posts again 0.55ms
DeleteFeed 4827.22ms
Maximum memory usage 837.01 MB = 58.25 MB + etc
Indexes folder size 10.01mb
arj03 commented 1 year ago

Thanks for the suggestions and bump :) Merged in now.

github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 364.98ms
Validate 5000 messages 448.18ms
Native to db format 5000 messages 128.30ms
Db to native format 5000 messages 108.84ms
Add 1000 elements 359.86ms
Add 1000 box1 msgs 906.86ms
Unbox 1000 box1 msgs first run 193.16ms
Unbox 1000 box1 msgs second run 92.79ms
Add 1000 box1 msgs 936.67ms
Query 1000 msgs first run 36.82ms
Query 1000 msgs second run 12.53ms
Add 1000 box2 msgs 1281.20ms
Unbox 1000 box2 msgs first run 312.61ms
Unbox 1000 box2 msgs second run 152.72ms
Migrate (+db1) 10891.83ms
Migrate (alone) 3512.50ms
Migrate (+db1 +db2) 7586.32ms
Migrate (+db2) 5851.44ms
Migrate continuation (+db2) 1016.67ms
Memory usage without indexes 764.62 MB = 41.82 MB + etc
Initial indexing 1408.35ms
Initial indexing maxcpu=86 4377.25ms
Initial indexing compat 651.72ms
Two indexes updating concurrently 2625.09ms
Key one initial 76.97ms
Key two 1.97ms
Key one again 1.03ms
Reboot and key one again 70.74ms
Latest root posts 1503.53ms
Latest posts 8.22ms
Votes one initial 1246.80ms
Votes again 0.39ms
HasRoot 1123.60ms
HasRoot again 0.31ms
Author one posts 1219.43ms
Author two posts 14.07ms
Dedicated author one posts 1207.80ms
Dedicated author one posts again 0.47ms
DeleteFeed 5283.03ms
Maximum memory usage 841.24 MB = 55.61 MB + etc
Indexes folder size 10.01mb
github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 382.58ms
Validate 5000 messages 531.19ms
Native to db format 5000 messages 128.21ms
Db to native format 5000 messages 106.32ms
Add 1000 elements 391.35ms
Add 1000 box1 msgs 1075.17ms
Unbox 1000 box1 msgs first run 210.94ms
Unbox 1000 box1 msgs second run 105.45ms
Add 1000 box1 msgs 1040.35ms
Query 1000 msgs first run 43.88ms
Query 1000 msgs second run 14.12ms
Add 1000 box2 msgs 1523.80ms
Unbox 1000 box2 msgs first run 388.03ms
Unbox 1000 box2 msgs second run 186.34ms
Migrate (+db1) 13807.06ms
Migrate (alone) 4595.85ms
Migrate (+db1 +db2) 9273.18ms
Migrate (+db2) 7096.37ms
Migrate continuation (+db2) 1245.86ms
Memory usage without indexes 756.67 MB = 45.80 MB + etc
Initial indexing 1741.83ms
Initial indexing maxcpu=86 5892.88ms
Initial indexing compat 907.42ms
Two indexes updating concurrently 2985.36ms
Key one initial 88.46ms
Key two 1.21ms
Key one again 1.30ms
Reboot and key one again 87.43ms
Latest root posts 1905.18ms
Latest posts 13.11ms
Votes one initial 1534.43ms
Votes again 0.72ms
HasRoot 1342.05ms
HasRoot again 0.61ms
Author one posts 1456.90ms
Author two posts 17.81ms
Dedicated author one posts 1472.08ms
Dedicated author one posts again 0.58ms
DeleteFeed 7365.83ms
Maximum memory usage 874.09 MB = 61.66 MB + etc
Indexes folder size 10.01mb
github-actions[bot] commented 1 year ago

Benchmark results

Part Duration
Create 5000 new messages 423.41ms
Validate 5000 messages 538.05ms
Native to db format 5000 messages 121.24ms
Db to native format 5000 messages 113.78ms
Add 1000 elements 387.61ms
Add 1000 box1 msgs 1059.58ms
Unbox 1000 box1 msgs first run 211.98ms
Unbox 1000 box1 msgs second run 102.95ms
Add 1000 box1 msgs 1003.03ms
Query 1000 msgs first run 42.58ms
Query 1000 msgs second run 19.21ms
Add 1000 box2 msgs 1465.31ms
Unbox 1000 box2 msgs first run 420.24ms
Unbox 1000 box2 msgs second run 213.60ms
Migrate (+db1) 12910.91ms
Migrate (alone) 4443.59ms
Migrate (+db1 +db2) 9104.59ms
Migrate (+db2) 6774.17ms
Migrate continuation (+db2) 1100.65ms
Memory usage without indexes 746.85 MB = 41.92 MB + etc
Initial indexing 1737.93ms
Initial indexing maxcpu=86 4288.58ms
Initial indexing compat 852.64ms
Two indexes updating concurrently 2886.89ms
Key one initial 82.03ms
Key two 2.19ms
Key one again 1.31ms
Reboot and key one again 93.92ms
Latest root posts 1821.27ms
Latest posts 10.59ms
Votes one initial 1462.51ms
Votes again 0.41ms
HasRoot 1293.68ms
HasRoot again 0.33ms
Author one posts 1438.35ms
Author two posts 16.93ms
Dedicated author one posts 1402.85ms
Dedicated author one posts again 0.69ms
DeleteFeed 6146.04ms
Maximum memory usage 864.65 MB = 59.13 MB + etc
Indexes folder size 10.01mb