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.
signature.asc
Description: This is a digitally signed message part
