Steve Muchai wrote:
Agreed, IMHO only user credentials should go into the database, plus other stuff like location of mailbox, status of account (enabled/disabled/vacation etc), quota details..... which is why I asked what's the reasoning behind wanting to store the actual messages in a database.
Two things mainly, ease of backup and speed (on large sites) The cons on the other hand will range from high database maintenance since DB will easly grow to TB without any management.
Totally agreed. Maildir works great, mbox doesn't scale well and is plagued with file locking issues.
For such a small site (less than 1000) the cost of investing in a RAID system with high capacity disks and high rpm is far cheaper than the headache of maintaining a db system. Nowadays Raid controllers are relatively inexpensive hence worth considering. I would look at it this way - go the DB way and reduce on the quota's or go the maildir and have your users with bigger quotas. Am sure the users will go with the latter. Regards, Mich.