You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by Craig Raw <cr...@quirk.co.za> on 2003/08/11 19:42:45 UTC

Db or dbfile?

Hi,

I apologize for what seems to be a newbie question, but I haven't been
able to find much information on this in the list archives, wiki or
docs. I'm trying to determine the pros/cons between the db and dbfile
persistance implementations. There is some related mention of MySQL
autoreconnect and other parameters in the archives to improve
throughput, but I'm still uncertain.

My context is the need to deliver through SMTP a large number of emails,
with receiving of lesser priority. What configuration would suit this?
Also, if anyone has any other tips to improve message delivery
performance, I'd be grateful.

Thanks in advance,
Craig


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


Re: Db or dbfile?

Posted by Craig Raw <cr...@quirk.co.za>.
Thanks for your insights.
Craig

----- Original Message ----- 
From: "Noel J. Bergman" <no...@devtech.com>
To: "James Users List" <se...@james.apache.org>
Sent: Monday, August 11, 2003 8:25 PM
Subject: RE: Db or dbfile?


> > I'm trying to determine the pros/cons between the db and dbfile
> > persistance implementations.
>
> Simple.  db stores everything in the database.  dbfile stores the headers
> and other status in the database, but stores the message body (potentially
> large) in the file system.
>
> Which is appropriate for you?  That's your call.
>
> > My context is the need to deliver through SMTP a large number of emails,
> > with receiving of lesser priority.
>
> Then you may care more about the spooler and RemoteDelivery repositories
> than the inbox.
>
> In my view, the advantage of dbfile is that it keeps large message bodies
> out of the database, which can be an issue if you have a lot of large
> messages, but the database spooling can be more robust in the face of
system
> overload than the file system.
>
> > any other tips to improve message delivery performance
>
> If you are evaluating, you might try the test builds.  There are
> optimizations in v2.2 compared to v2.1.
>
> --- Noel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
> For additional commands, e-mail: server-user-help@james.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org


RE: Db or dbfile?

Posted by "Noel J. Bergman" <no...@devtech.com>.
> I'm trying to determine the pros/cons between the db and dbfile
> persistance implementations.

Simple.  db stores everything in the database.  dbfile stores the headers
and other status in the database, but stores the message body (potentially
large) in the file system.

Which is appropriate for you?  That's your call.

> My context is the need to deliver through SMTP a large number of emails,
> with receiving of lesser priority.

Then you may care more about the spooler and RemoteDelivery repositories
than the inbox.

In my view, the advantage of dbfile is that it keeps large message bodies
out of the database, which can be an issue if you have a lot of large
messages, but the database spooling can be more robust in the face of system
overload than the file system.

> any other tips to improve message delivery performance

If you are evaluating, you might try the test builds.  There are
optimizations in v2.2 compared to v2.1.

	--- Noel


---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org