github-actions[bot]
commented
1 year ago Benchmark results
| Part | Duration |
|---|---|
| Create 5000 new messages | 368.50ms |
| Validate 5000 messages | 448.87ms |
| Native to db format 5000 messages | 133.31ms |
| Db to native format 5000 messages | 87.13ms |
| Add 1000 elements | 522.64ms |
| Add 1000 box1 msgs | 937.23ms |
| Unbox 1000 box1 msgs first run | 220.98ms |
| Unbox 1000 box1 msgs second run | 103.01ms |
| Add 1000 box1 msgs | 904.02ms |
| Query 1000 msgs first run | 39.47ms |
| Query 1000 msgs second run | 22.98ms |
| Add 1000 box2 msgs | 1297.41ms |
| Unbox 1000 box2 msgs first run | 339.62ms |
| Unbox 1000 box2 msgs second run | 151.35ms |
| Migrate (+db1) | 11840.34ms |
| Migrate (alone) | 3979.39ms |
| Migrate (+db1 +db2) | 8259.00ms |
| Migrate (+db2) | 6196.09ms |
| Migrate continuation (+db2) | 1204.59ms |
| Memory usage without indexes | 757.43 MB = 37.74 MB + etc |
| Initial indexing | 1735.55ms |
| Initial indexing maxcpu=86 | 5028.50ms |
| Initial indexing compat | 677.80ms |
| Two indexes updating concurrently | 2947.23ms |
| Key one initial | 53.16ms |
| Key two | 0.53ms |
| Key one again | 1.96ms |
| Reboot and key one again | 43.37ms |
| Latest root posts | 1741.00ms |
| Latest posts | 10.23ms |
| Votes one initial | 1516.96ms |
| Votes again | 0.59ms |
| HasRoot | 1305.77ms |
| HasRoot again | 0.31ms |
| Author one posts | 1427.55ms |
| Author two posts | 15.99ms |
| Dedicated author one posts | 1449.55ms |
| Dedicated author one posts again | 0.51ms |
| DeleteFeed | 141854.89ms |
| Maximum memory usage | 975.20 MB = 55.57 MB + etc |
| Indexes folder size | 10.01mb |
arj03
staltz
This fixes #402. No need to load up all the offsets into memory if we just delete all of them anyway.