On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz wrote:
On January 30, 2022 5:46:53 PM AKST, dovecot@ptld.com wrote:
Storing mail in a db... at the end of the day isn't it still just a file (.db file) on the drive?
Aren't you just adding bloat and complexity vs just storing the mail directly (maildir format) to a file on the drive? [...]
You'll get better indexing and fast full text search by storing your emails in a database rather than a flat file, hopefully after decoding any attachments. Especially for spam scoring, analysis, and classification. Much better performance deleting or moving specific messages, too.
Do you have evidence to back up these claims, specifically re: mail servers?
Like-for-like benchmarks, for instance?
Thanks,
Sam
-- A: When it messes up the order in which people normally read text. Q: When is top-posting a bad thing?
() ASCII ribbon campaign. Please avoid HTML emails & proprietary /\ file formats. (Why? See e.g. https://v.gd/jrmGbS ). Thank you.