Well yes Exchange does have it's problems (its much better than it used to be), but ya gotta remember the underlying "DB" is Access.
I think there are moves afoot for the next version of MS-Ex to be able to run with SQl-Server as the backend datastore (2003 may already have this ability) which is v. usefull for large (1000+) user bases. Kinda proves the point really, you need a proper DB for this sort of thing not some tin pot 'user' thing. -- Martin Hepworth Snr Systems Administrator Solid State Logic Tel: +44 (0)1865 842300 > -----Original Message----- > From: Rob McEwen [mailto:[EMAIL PROTECTED] > Sent: 09 June 2006 23:16 > To: users@spamassassin.apache.org > Subject: RE: The Future of Email is SQL > > > >>MS Exchange... one big Database > > Exactly... > > And that is one reason why I wouldn't touch this SQL idea with a 10 foot > pole.. the fact that Exchange works this way only proves my point... I > hear > all the time about Exchange servers crashing and the administrator having > to > rebuild the database while the mail server is down for the next 10 hours. > > The bottom line is that using a SQL DB backend as mail storage is putting > all your eggs in one basket. > > I have a much simpler solution to accomplish the problem that this was > idea > was originally attempting to solve... simply place the spams that are > caught > in a folder on the mail server that is accessible via webmail. Then create > a > separate program to periodically enumerate through the spam folder in all > the accounts on the server to delete spams over X days old. > > If needed, you could still have a database with the basic info about the > spams (date received, subject line, recipients, from, message file name, > etc) to use for e-mailing "digests" to the user... and this DB's stability > wouldn't then have to be tied to the overall reliability/stability of mail > services. > > Also keep in mind that SQL doesn't always mean better performance... I've > seen many web sites that deliver content dynamically from a SQL database > backend where there were noticeably large delays between page loads, for > example. > > Rob McEwen > PowerView Systems > [EMAIL PROTECTED] > ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote confirms that this email message has been swept for the presence of computer viruses and is believed to be clean. **********************************************************************
