Re: email with a database

2006-05-21 Thread Olivier Nicole
> > is there an email solution that employs some kind of database that stores
> > mail for long term?  id rather not turn on "leave a copy on the server" as
> > this has shown to give poorer and poorer performance over time for me.
> People normally take backups of their machines in order to protect 
> against losing files, including your email.  You should be using IMAP 
> instead of POP3 if you want your email to reside on the server efficiently.

In fact you would want to use maildir format instead of mbox format
for your mailbox. That you use imap or pop3 is of little relevance on
the speed. Format of the mailbox is though.

In standard mbox format you have to open and manipulate one single
huge file, that keeps growing bigger and bigger. Browsing that file to
find the new/unseen messages can take several tens of second when your
mailbox gets too big.

In maildir format, you manipulates one file per message, new messages
being in a different directory from the seen messages. That makes the
file manipulation much faster.

Of course you can make tape archive of your mailbox (easier to archive
maildir format though as there is not risk of concurent access to a
message file).

And you can use procmail or the like to duplicate the message in a
file on your server.

Best regards,

Olivier
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"


Re: email with a database

2006-05-20 Thread Lowell Gilbert
Chuck Swiger <[EMAIL PROTECTED]> writes:

> Jonathan Horne wrote:
>> is there an email solution that employs some kind of database that stores
>> mail for long term?  id rather not turn on "leave a copy on the server" as
>> this has shown to give poorer and poorer performance over time for me.
>>   
>
> People normally take backups of their machines in order to protect 
> against losing files, including your email.  You should be using IMAP 
> instead of POP3 if you want your email to reside on the server efficiently.

That would be my first reaction, too.  But I suspect there are a lot
of different possible requirements for this kind of storage, and if
you really want to archive everything, keeping it out of your normal
mailboxes would be more efficient and less prone to losing archives
you wanted to keep.  

Most MTAs can be configured to save all mail on the way through, and
I've known people to use procmail to do similar things.  Depends on
why you want the archive.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"


Re: email with a database

2006-05-20 Thread Chuck Swiger

Jonathan Horne wrote:

is there an email solution that employs some kind of database that stores
mail for long term?  id rather not turn on "leave a copy on the server" as
this has shown to give poorer and poorer performance over time for me.
  


People normally take backups of their machines in order to protect 
against losing files, including your email.  You should be using IMAP 
instead of POP3 if you want your email to reside on the server efficiently.


--
-Chuck

___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"