Post #2447767
2026-03-07 12:22 UTC
@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.
Replies (1)
-
@wouter@pleroma.debian.social 2026-03-07 13:39
@bert_hubert@eupolicy.social I didn't mean to offend, but "sqlite can't be as fast as LMDB because of its design choices" is the statement *I* was trying (but perhaps failing) to make. That doesn't make those design choices invalid -- in most cases I prefer SQL for ease of debugging -- but if performance *really* matters, LMDB is really the only option. That doesn't mean 'everything else is slow', just that LMDB is faster @hyc@mastodon.social @Archivist@social.linux.pizza