7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] Message Storage i...
FromSent OnAttachments
Michael KingsburyMar 10, 2002 10:35 pm 
Sam VarshavchikMar 10, 2002 11:04 pm 
Michael KingsburyMar 10, 2002 11:20 pm 
SysopMar 11, 2002 1:22 am 
Michael L. BarrowMar 11, 2002 1:54 am 
Matthew NuzumMar 11, 2002 7:01 am 
Gordon MessmerMar 11, 2002 8:29 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [courier-users] Message Storage in a SQL database (ie MySQL)Actions...
From:Gordon Messmer (yiny@eburg.com)
Date:Mar 11, 2002 8:29:40 am
List:net.sourceforge.lists.courier-users

On Sun, 2002-03-10 at 22:34, Michael Kingsbury wrote:

I was wondering if anyone's given any thought (and/or tried) to store messages in a SQL database as opposed to the conventional flat-file style? I would think this would scale better than the MailDir format...

I'd wonder why you thought that. A relational DB storing mail messages (ala Exchange? Haven't we learned better yet?) shouldn't be any more efficient than a good file system. Either way, retrieving a message is a namespace lookup (whether query parameters or path) that returns the message data. You should be able to cluster file servers as easily (or more) as DB servers.

Keeping the data in flat files also keeps your security in the OS. I would place a higher degree of trust in the security of my OS than any database server.