Hi, Storing them in a db gives you potentially a number of advantages some of which are listed below.. 1/ it allows any application capable of connecting and using SQL to access the information, such as a webmail application, account management, or inserting messages directly into the spooler (instead of via SMTP) 2/ it allows the datastorage to be managed seperately from the mailserver, you can locate it on another machine 3/ you can take advantage of some of the architectural features of databases, such as scalability, fail-over. 4/ databases are better for dealing with large quantities of data, for instance we are about to use James to collate replies and bounces to a regular mailshot in excess of 2.5 million messages. To do this we can have several instances of James feed mail into a single central database (with hot backup) and create reports of summary and specific information.
I've just seen serge's reply.. and agree that it makes housekeeping simpler too, I use (at home) MySQL for James on a Linux box and "watch" the repositories (just 'cos I'm a nosy geek!) using M$ Access "linked tables" via ODBC. d. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:40 PM > To: [EMAIL PROTECTED] > Subject: Why use a DB? > > > I see that it is possible to get JAMES to use an SQL database for > persistent storage instead of the standard XML files. What is the > advantage of doing this? > > TIA > > ADK > > > ------------------------------------------------------------------ > ----------------------------- > Have you seen our website?.... http://www.vodafone.co.nz > > CAUTION: This correspondence is confidential and intended for the > named recipient(s) only. > If you are not the named recipient and receive this > correspondence in error, you must not copy, > distribute or take any action in reliance on it and you should > delete it from your system and > notify the sender immediately. Thank you. > > Unless otherwise stated, any views or opinions expressed are > solely those of the author and do > not represent those of Vodafone New Zealand Limited. > > Vodafone New Zealand Limited > 21 Pitt Street, Private Bag 92161, Auckland, 1020, New Zealand > Telephone + 64 9 357 5100 > Facsimile + 64 9 377 0962 > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
