Just on a related note.
M$ Exchange uses a database to store Email. They go on about how wonderful
it is, but from personal experience I can tell you it's a "fair weather
friend" - works well when it's going, but when any problems occur - you have
no idea where to start looking for a solution. Database corruption is of
course the worst thing that can happen you to - sometimes restoring from
backup doesn't even help as the DB was corrupted days/weeks earlier but just
didn't die until recently :-(
Thing is: M$ Exchange _doesn't_ use a SQL server backend - it uses a version
of the M$ JET database specifically re-written to efficiently handle Email.
M$ were intending moving Exchange to M$-SQL (via Transaction Server) - but
gave up that idea as the performance would never be as good.
I think it would be fair to deduce from that, that a major player in this
market doesn't think SQL is appropriate for Email - draw what you will from
that...
--
Cheers
Jason Haar
Unix/Network Specialist, Trimble NZ
Phone: +64 3 3391 377 Fax: +64 3 3391 417
