Post #2447766
2026-03-07 12:20 UTC
@bert_hubert@eupolicy.social
You mean like https://www.sqlitetutorial.net/sqlite-blob/, correct?
Your SQL engine would still be involved, and needs to do string parsing just to understand what it is you want to store in binary. Yes it's faster than converting to base64 and back, but not as fast as a memcpy ala LMDB.
I said "*really*" for a reason 😉
@hyc@mastodon.social @Archivist@social.linux.pizza
Replies (1)
-
@bert_hubert@eupolicy.social 2026-03-07 12:22
@wouter@pleroma.debian.social @hyc@mastodon.social @Archivist@social.linux.pizza I suggest trusting me on this one. There is no string parsing involved with a prepared query where the parser only sees '?' and that only once. Also I never stated anything about this being as fast as lmdb, please respond to things I actually said.