<html><head></head><body>Just ideas.<br><br>Removing or deleting a single message from near the beginning of a large flat file takes an inordinate amount of time because the remainder of the flat file has to be rewritten all the way from the point of the deleted message to the end of the file and then truncated.<br><br><div class="gmail_quote">On January 30, 2022 6:30:44 PM AKST, Sam Kuper <sampablokuper@posteo.net> wrote:<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<pre dir="auto" class="k9mail">On Sun, Jan 30, 2022 at 06:17:49PM -0900, justina colmena ~biz wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">On January 30, 2022 5:46:53 PM AKST, dovecot@ptld.com wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> Storing mail in a db... at the end of the day isn't it still just a<br> file (.db file) on the drive?<br><br> Aren't you just adding bloat and complexity vs just storing the mail<br> directly (maildir format) to a file on the drive? [...]<br></blockquote><br> You'll get better indexing and fast full text search by storing your<br> emails in a database rather than a flat file, hopefully after decoding<br> any attachments. Especially for spam scoring, analysis, and<br> classification. Much better performance deleting or moving specific<br> messages, too.<br></blockquote><br>Do you have evidence to back up these claims, specifically re: mail<br>servers?<br><br>Like-for-like benchmarks, for instance?<br><br>Thanks,<br><br>Sam<br><br><div class="k9mail-signature">-- <br>A: When it messes up the order in which people normally read text.<br>Q: When is top-posting a bad thing?<br><br>() ASCII ribbon campaign. Please avoid HTML emails & proprietary<br>/\ file formats. (Why? See e.g. <a href="https://v.gd/jrmGbS">https://v.gd/jrmGbS</a> ). Thank you.<br></div></pre></blockquote></div><div style='white-space: pre-wrap'><div class='k9mail-signature'>-- <br>Sent from my Android device with K-9 Mail. Please excuse my brevity.</div></div></body></html>