tonbo-io / tonbo

A portable embedded database using Arrow.
https://tonbo.io
Apache License 2.0
795 stars 46 forks source link

refactor: update fusio & use DynWrite in wal instead #210

Closed ethe closed 2 weeks ago

github-actions[bot] commented 2 weeks ago

Read:

+--------------------------------------------+---------+---------+
|                                            | tonbo   | rocksdb |
+================================================================+
| random range reads                         | 84022ms | 36887ms |
|--------------------------------------------+---------+---------|
| random range reads                         | 79335ms | 37066ms |
|--------------------------------------------+---------+---------|
| random range projection reads              | 40312ms | 37412ms |
|--------------------------------------------+---------+---------|
| random range projection reads              | 38521ms | 37369ms |
|--------------------------------------------+---------+---------|
| random range projection reads (4 threads)  | 32005ms | 37360ms |
|--------------------------------------------+---------+---------|
| random range projection reads (8 threads)  | 31919ms | 37389ms |
|--------------------------------------------+---------+---------|
| random range projection reads (16 threads) | 27582ms | 35949ms |
|--------------------------------------------+---------+---------|
| random range projection reads (32 threads) | 23718ms | 35957ms |
+--------------------------------------------+---------+---------+
github-actions[bot] commented 2 weeks ago

Write:

+-------------------------------+--------+---------+
|                               | tonbo  | rocksdb |
+==================================================+
| bulk load                     | 6378ms | 9400ms  |
|-------------------------------+--------+---------|
| individual writes             | 8208ms | 10464ms |
|-------------------------------+--------+---------|
| individual writes (4 threads) | 8142ms | 10450ms |
|-------------------------------+--------+---------|
| individual writes (8 threads) | 7723ms | 10349ms |
|-------------------------------+--------+---------|
| batch writes                  | 7974ms | 7192ms  |
|-------------------------------+--------+---------|
| batch writes (4 threads)      | 7740ms | 7119ms  |
|-------------------------------+--------+---------|
| batch writes (8 threads)      | 7650ms | 7057ms  |
|-------------------------------+--------+---------|
| removals                      | 3093ms | 3800ms  |
+-------------------------------+--------+---------+
github-actions[bot] commented 2 weeks ago

Read:

+--------------------------------------------+---------+---------+
|                                            | tonbo   | rocksdb |
+================================================================+
| random range reads                         | 95932ms | 37258ms |
|--------------------------------------------+---------+---------|
| random range reads                         | 94727ms | 37251ms |
|--------------------------------------------+---------+---------|
| random range projection reads              | 42483ms | 37936ms |
|--------------------------------------------+---------+---------|
| random range projection reads              | 42368ms | 37948ms |
|--------------------------------------------+---------+---------|
| random range projection reads (4 threads)  | 33256ms | 37892ms |
|--------------------------------------------+---------+---------|
| random range projection reads (8 threads)  | 32968ms | 37871ms |
|--------------------------------------------+---------+---------|
| random range projection reads (16 threads) | 28075ms | 36430ms |
|--------------------------------------------+---------+---------|
| random range projection reads (32 threads) | 22792ms | 36392ms |
+--------------------------------------------+---------+---------+
github-actions[bot] commented 2 weeks ago

Write:

+-------------------------------+--------+---------+
|                               | tonbo  | rocksdb |
+==================================================+
| bulk load                     | 6373ms | 9421ms  |
|-------------------------------+--------+---------|
| individual writes             | 8330ms | 10573ms |
|-------------------------------+--------+---------|
| individual writes (4 threads) | 8115ms | 10579ms |
|-------------------------------+--------+---------|
| individual writes (8 threads) | 7755ms | 10626ms |
|-------------------------------+--------+---------|
| batch writes                  | 8077ms | 7146ms  |
|-------------------------------+--------+---------|
| batch writes (4 threads)      | 7760ms | 7103ms  |
|-------------------------------+--------+---------|
| batch writes (8 threads)      | 7675ms | 7155ms  |
|-------------------------------+--------+---------|
| removals                      | 3102ms | 3788ms  |
+-------------------------------+--------+---------+