fiatjaf on Nostr: According to benchmarks at my LMDB-based store is 4000x faster than SQLite.
According to benchmarks at https://github.com/fiatjaf/eventstore my LMDB-based store is 4000x faster than SQLite.
fiatjaf
npub180…jh6w6
2024-12-20 00:46:25 GMT
in reply to nevent1q…r220
Author Public Key
npub180cvv07tjdrrgpa0j7j7tmnyl2yr6yr7l8j4s3evf6u64th6gkwsyjh6w6Seen on
wss://relay.nostr.bandPublished at
2024-12-20 00:46:25 GMTEvent JSON
{
"id": "0000b6e2e6558320632a1114b488d0136501862d0120e8313f06ae8a0fa4762c",
"pubkey": "3bf0c63fcb93463407af97a5e5ee64fa883d107ef9e558472c4eb9aaaefa459d",
"created_at": 1734655585,
"kind": 1,
"tags": [
[
"p",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"p",
"24cf5e0ea5ffe5e084bdf7195f793e60c3278e5e6a6819a67865b90e9904d481"
],
[
"p",
"a80455732d5bfa792f279011a8c871853182971994752b9cf1169611ff91a578"
],
[
"e",
"f75aab509d8d0d2b24152803fdb2d2cf1c8e725dc027fe919db00bfa5162d881",
"wss://wot.utxo.one/",
"root"
],
[
"e",
"cd73bc560be11d613fd104a99e35cf05551007fff6c4491459a1340d7b21fc42",
"wss://wot.utxo.one/",
"reply",
"32e1827635450ebb3c5a7d12c1f8e7b2b514439ac10a67eef3d9fd9c5c68e245"
],
[
"nonce",
"13835058055282171648",
"16"
]
],
"content": "According to benchmarks at https://github.com/fiatjaf/eventstore my LMDB-based store is 4000x faster than SQLite.",
"sig": "65fa976d7c67d46faa413c0663ea49b112bb9efb0982e7c300c920fb4ed031f801dbcb0190fd8671f7531e2e88d61235b1ad1ec1bb7de93a0071886b95d99995"
}