dovecot - Jan 2022 - silly quesiton [ot]

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.

On January 30, 2022 5:46:53 PM AKST, dovecot at 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?
>
>What do you think you are saving? Security?
>If someone can read files on your server, they can equally read a maildir or
a .db file.
>K.I.S.S.
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<https://dovecot.org/pipermail/dovecot/attachments/20220130/e0722f10/attachment-0001.htm>

On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz
wrote:
> On January 30, 2022 5:46:53 PM AKST, dovecot at 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.