@SuperFloppies Mastodon's already doing many lookups for every incoming message, for timeline insertion, FWIW
@bhtooefr Well, that is a design issue and not strictly needed for the implementation. But in that case, if the new lookup fits into the old ones it adds just a branch to the code. I wouldn’t assume that tho.
Replying to a very old post will have the highest cost. “One lookup” sounds small, but remember that no implication is made on the amount of I/O required for that one lookup.
Cache effect does not exist for old data.
@bhtooefr “design issue” meant to say “design detail”. Not sure how issue came out there.
This Mastodon instance is for people interested in technology. Discussions aren't limited to technology, because tech folks shouldn't be limited to technology either!