girinovey on Nostr: final benchmark, using an nvme SSD, and including badger: badger is 2 times slower ...

final benchmark, using an nvme SSD, and including badger:

badger is 2 times slower than lmdb on queries, but orders of magnitude faster on stores (27s for badger and 16 minutes for lmdb).

slicestore is still an order of magnitude faster on stores than badger. Performance gains of using slice store range from 2 to 8 times over lmdb, and 10 to 24 times over badger.

My preliminary conclusion:
- memory only is a good solution for restricted environments, specially with slow disks.
- badger should be a better choice for public relays, or relays that "copy" data from upstream relays, since storage cost is lower than in lmdb.
- lmdb is best for personal relays with few writes, but a lot of reads. though i'd use badger on those too.