james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Donald <dona...@apache.org>
Subject Re: Input for JDB Mail Repository
Date Tue, 31 Jul 2001 11:18:21 GMT
On Tue, 31 Jul 2001 21:15, Charles Benett wrote:
> In cvs proposal dir is Serge's JDBCMailRepository and
> JDBCSpoolRepository.
> Serge uses Mssql server with Inet Sprinta (I think) and I have got it
> going with MySQL and the mm driver.
> This is intended to replace the town db classses in James 1.2.1
>
> At the moment, they new classes need to be re-compiled for different
> drivers and dbs.
> I want to tidy up the config and move them into the main tree.
> So I am looking for input from developers/ users.

+1 ;)

> 1) At the moment the JDBCMailRepository (like the town repository) puts
> all messages in one db table.
> a) Would it be useful to allows different tables, e.g. one for spam
> another for errors etc.?

I would have one for spool mail, one for spool mail envelope, and one for local deliveries.

> b) If one had multiple tables, how likely is it that one would have them
> in different dbs or on different machines?

highly unlikely I would think ;)

> c) If one had multiple tables, would we still want all POP3 inboxes to
> be in one table or would per-user tables make sense?

per-user tables would be a nightmare ! ;)

Think what would happen to your DB if you had 300 users ;)

> Any other suggestions re storing mail in a db would be welcome.
>
> Charles
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: james-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: james-dev-help@jakarta.apache.org

-- 
Cheers,

Pete

*-----------------------------------------------------*
| "Faced with the choice between changing one's mind, |
| and proving that there is no need to do so - almost |
| everyone gets busy on the proof."                   |
|              - John Kenneth Galbraith               |
*-----------------------------------------------------*

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


Mime
View raw message