Hm, this comment from 88 days ago is showing in my google alert as 2 days old. Google is srsly messed up.
https://news.ycombinator.com/item?id=45101592
But as to the question: #LMDB doesn't store counts of child nodes in each parent page. Doing so would certainly allow for setting a cursor directly to an Nth record, and redhat even submitted a ticket requesting this feature but it didn't seem important enough at the time, and seemed like too much storage cost for a rarely used function.
Howard Chu @ Symas
npub1tt…ex9ud
2025-11-30 08:51:47 UTC
Author Public Key
npub1tt4j2zeswksjh5z7zmy283qd4yd920afy9j28xg45wsxzhl9rpjqrex9udSeen on
wss://relay.ditto.pubPublished at
2025-11-30 08:51:47 UTCEvent JSON
{
"id": "03f766e4361686e954eed089e132825930e49245b0def41fc81f14011df4b4f0",
"pubkey": "5aeb250b3075a12bd05e16c8a3c40da91a553fa92164a39915a3a0615fe51864",
"created_at": 1764492707,
"kind": 1,
"tags": [
[
"t",
"lmdb"
],
[
"proxy",
"https://mastodon.social/users/hyc/statuses/115637794077301320",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub/"
]
],
"content": "Hm, this comment from 88 days ago is showing in my google alert as 2 days old. Google is srsly messed up.\n\nhttps://news.ycombinator.com/item?id=45101592\n\nBut as to the question: #LMDB doesn't store counts of child nodes in each parent page. Doing so would certainly allow for setting a cursor directly to an Nth record, and redhat even submitted a ticket requesting this feature but it didn't seem important enough at the time, and seemed like too much storage cost for a rarely used function.",
"sig": "8cce64ba707ce4531ff693f602fadfee599d9939fb5639012630eaa42da85b1a7db097201b33e18898c931d4c5c9c5cc81bb6419af739d9640882e86cc4bcd64"
}