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 Brady Moritz <br...@moritzdesigns.com> on 2001/08/23 08:58:48 UTC
db vs. file
Apologize if this is an over-asked question, but is using a db server
(mostly just for the smtp spool) a big perfomance hit compared to a
filesystem spool? Im considering using posgres on a linux box.
Thanks
Brady Moritz
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: db vs. file/ other stuff
Posted by Brady Moritz <br...@moritzdesigns.com>.
What can I say, must be reading my mind again. Thanks once more, Serge.
Although Im not a drinker, I'll buy yah a beer if you are ever in the
Houston area ;)
Brady
-----Original Message-----
From: Serge Knystautas [mailto:sergek@lokitech.com]
Sent: Friday, August 24, 2001 7:05 AM
To: james-user@jakarta.apache.org
Subject: Re: db vs. file/ other stuff
I actually wrote a mailet to do that rather recently, and it's in the latest
version of CVS. It's called AddFooter and can add a text message to both
text and html messages. It also determines if the message has attachments
and/or alternative content type (both text and html versions) and should do
a respectable job of adding the footer in those cases. The mailet API
hasn't changed, so you can probably get it from the daily build or from CVS.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Brady Moritz" <br...@moritzdesigns.com>
To: <ja...@jakarta.apache.org>
Sent: Friday, August 24, 2001 12:28 AM
Subject: RE: db vs. file/ other stuff
> Serge, thanks once more for the input.
>
> I guess I'll go ahead and ask the group for any pointers on what I am am
> considering using james for. The basic function will be to attach a small
> trailer to every message going through the smtp server, yes kindof like
> those annoying ads that hotmail and others use, but this is to be utilized
> by a non-profit organization. What I am going to need to figure out is
the
> simplest way to handle a number of message mime types, from plain ol text
to
> html and other mixed multi-part messages. Before I go nuts figuring out
all
> the mime stuff, can any of you suggest a scheme for attaching the short
> message in a way that will work across many or even all message types?
>
> Thanks guys
>
> Brady Moritz
>
> -----Original Message-----
> From: Serge Knystautas [mailto:sergek@lokitech.com]
> Sent: Thursday, August 23, 2001 11:18 AM
> To: james-user@jakarta.apache.org
> Subject: Re: db vs. file
>
>
> The DB is certainly slower than file, no doubt. However, I've noticed
that
> unless you're sending lots of emails (thousands an hour), it's still
> acceptable. For my JDBC driver though, I found that performance dropped
off
> geometrically in relation to the size of the message, not so much the
number
> of messages. So a 1 meg message was maybe 100 times slower than a 100k
> message.
>
> The latest code in CVS greatly optimizes the DB access, and mail/spool
> repositories in general.
>
> Serge Knystautas
> Loki Technologies
> http://www.lokitech.com/
> ----- Original Message -----
> From: "Brady Moritz" <br...@moritzdesigns.com>
> To: <ja...@jakarta.apache.org>
> Sent: Thursday, August 23, 2001 2:58 AM
> Subject: db vs. file
>
>
> > Apologize if this is an over-asked question, but is using a db server
> > (mostly just for the smtp spool) a big perfomance hit compared to a
> > filesystem spool? Im considering using posgres on a linux box.
> >
> > Thanks
> >
> > Brady Moritz
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: db vs. file/ other stuff
Posted by Serge Knystautas <se...@lokitech.com>.
I actually wrote a mailet to do that rather recently, and it's in the latest
version of CVS. It's called AddFooter and can add a text message to both
text and html messages. It also determines if the message has attachments
and/or alternative content type (both text and html versions) and should do
a respectable job of adding the footer in those cases. The mailet API
hasn't changed, so you can probably get it from the daily build or from CVS.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Brady Moritz" <br...@moritzdesigns.com>
To: <ja...@jakarta.apache.org>
Sent: Friday, August 24, 2001 12:28 AM
Subject: RE: db vs. file/ other stuff
> Serge, thanks once more for the input.
>
> I guess I'll go ahead and ask the group for any pointers on what I am am
> considering using james for. The basic function will be to attach a small
> trailer to every message going through the smtp server, yes kindof like
> those annoying ads that hotmail and others use, but this is to be utilized
> by a non-profit organization. What I am going to need to figure out is
the
> simplest way to handle a number of message mime types, from plain ol text
to
> html and other mixed multi-part messages. Before I go nuts figuring out
all
> the mime stuff, can any of you suggest a scheme for attaching the short
> message in a way that will work across many or even all message types?
>
> Thanks guys
>
> Brady Moritz
>
> -----Original Message-----
> From: Serge Knystautas [mailto:sergek@lokitech.com]
> Sent: Thursday, August 23, 2001 11:18 AM
> To: james-user@jakarta.apache.org
> Subject: Re: db vs. file
>
>
> The DB is certainly slower than file, no doubt. However, I've noticed
that
> unless you're sending lots of emails (thousands an hour), it's still
> acceptable. For my JDBC driver though, I found that performance dropped
off
> geometrically in relation to the size of the message, not so much the
number
> of messages. So a 1 meg message was maybe 100 times slower than a 100k
> message.
>
> The latest code in CVS greatly optimizes the DB access, and mail/spool
> repositories in general.
>
> Serge Knystautas
> Loki Technologies
> http://www.lokitech.com/
> ----- Original Message -----
> From: "Brady Moritz" <br...@moritzdesigns.com>
> To: <ja...@jakarta.apache.org>
> Sent: Thursday, August 23, 2001 2:58 AM
> Subject: db vs. file
>
>
> > Apologize if this is an over-asked question, but is using a db server
> > (mostly just for the smtp spool) a big perfomance hit compared to a
> > filesystem spool? Im considering using posgres on a linux box.
> >
> > Thanks
> >
> > Brady Moritz
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
RE: db vs. file/ other stuff
Posted by Brady Moritz <br...@moritzdesigns.com>.
Serge, thanks once more for the input.
I guess I'll go ahead and ask the group for any pointers on what I am am
considering using james for. The basic function will be to attach a small
trailer to every message going through the smtp server, yes kindof like
those annoying ads that hotmail and others use, but this is to be utilized
by a non-profit organization. What I am going to need to figure out is the
simplest way to handle a number of message mime types, from plain ol text to
html and other mixed multi-part messages. Before I go nuts figuring out all
the mime stuff, can any of you suggest a scheme for attaching the short
message in a way that will work across many or even all message types?
Thanks guys
Brady Moritz
-----Original Message-----
From: Serge Knystautas [mailto:sergek@lokitech.com]
Sent: Thursday, August 23, 2001 11:18 AM
To: james-user@jakarta.apache.org
Subject: Re: db vs. file
The DB is certainly slower than file, no doubt. However, I've noticed that
unless you're sending lots of emails (thousands an hour), it's still
acceptable. For my JDBC driver though, I found that performance dropped off
geometrically in relation to the size of the message, not so much the number
of messages. So a 1 meg message was maybe 100 times slower than a 100k
message.
The latest code in CVS greatly optimizes the DB access, and mail/spool
repositories in general.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Brady Moritz" <br...@moritzdesigns.com>
To: <ja...@jakarta.apache.org>
Sent: Thursday, August 23, 2001 2:58 AM
Subject: db vs. file
> Apologize if this is an over-asked question, but is using a db server
> (mostly just for the smtp spool) a big perfomance hit compared to a
> filesystem spool? Im considering using posgres on a linux box.
>
> Thanks
>
> Brady Moritz
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org
Re: db vs. file
Posted by Serge Knystautas <se...@lokitech.com>.
The DB is certainly slower than file, no doubt. However, I've noticed that
unless you're sending lots of emails (thousands an hour), it's still
acceptable. For my JDBC driver though, I found that performance dropped off
geometrically in relation to the size of the message, not so much the number
of messages. So a 1 meg message was maybe 100 times slower than a 100k
message.
The latest code in CVS greatly optimizes the DB access, and mail/spool
repositories in general.
Serge Knystautas
Loki Technologies
http://www.lokitech.com/
----- Original Message -----
From: "Brady Moritz" <br...@moritzdesigns.com>
To: <ja...@jakarta.apache.org>
Sent: Thursday, August 23, 2001 2:58 AM
Subject: db vs. file
> Apologize if this is an over-asked question, but is using a db server
> (mostly just for the smtp spool) a big perfomance hit compared to a
> filesystem spool? Im considering using posgres on a linux box.
>
> Thanks
>
> Brady Moritz
---------------------------------------------------------------------
To unsubscribe, e-mail: james-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: james-user-help@jakarta.apache.org