girinovey on Nostr: with only 24h data, it takes about 3ms to do a full scan in the database. (i haven't ...
with only 24h data, it takes about 3ms to do a full scan in the database. (i haven't implemented any indexes yet, will need indexes for a larger database). Not sure how it compares to lmdb, but it sure uses a lot less I/O (which is my main problem in the raspberry pi) :-D
Published at
2024-10-24 18:07:16Event JSON
{
"id": "a97d17383c9f12b5195a1276d2b5bbf9d569817da1f7c0044b402589764b313f",
"pubkey": "3ffac3a6c859eaaa8cdddb2c7002a6e10b33efeb92d025b14ead6f8a2d656657",
"created_at": 1729793236,
"kind": 1,
"tags": [
[
"e",
"80a2885047628b116d72245192bdf3e2cfbbecfae5e828fa6500d5b1dd7aaf11",
"",
"root"
],
[
"e",
"d2c36a80db4d9931328be809d3263e94fdd5baf2b1473dc3180f77710819380c",
"",
"reply"
],
[
"p",
"e2ccf7cf20403f3f2a4a55b328f0de3be38558a7d5f33632fdaaefc726c1c8eb"
],
[
"p",
"3ffac3a6c859eaaa8cdddb2c7002a6e10b33efeb92d025b14ead6f8a2d656657"
]
],
"content": "with only 24h data, it takes about 3ms to do a full scan in the database. (i haven't implemented any indexes yet, will need indexes for a larger database). Not sure how it compares to lmdb, but it sure uses a lot less I/O (which is my main problem in the raspberry pi) :-D",
"sig": "4d9032b4909be70c7c47612a2eed1b7c5bb27f7509d8a52d3ceb7804c669950133e0c430eb2edabfedad8fc253a57963a15ca02ce7e4aee216a887b4653b9dd1"
}
