>
> What is your setup in this case? I have yet to find a character I can't
insert into a SQL Server 7 char/varchar/text field via ODBC and a simple INSERT
statement. I'm curious because a couple of people have mentioned this, but I've
never had such a problem with SS7 (Access, yes).
>
> Otherwise I generally agree that storing mail in flat files makes a lot of
sense for many reasons. >I can see how storing it all in the DB might be useful
in a specialized application though.
Well yes - I agree there. For ISP, or large scale email provision clearly out
and out performance is the order of the day, and as users aren't paying much, if
anything, for the service, then all of the bells and whistles are just not
appropriate generally speaking.
If OTOH one is providing corporate email services, and the customer is paying
for a first rate mail service, then equally clearly SQL based message storage
opens up a whole new range of possibilities of considerable value to corporate
and other large organisations - services which would put iMS way ahead of the
rest if it could do that.
Of course - equally important to corporate organisations would be Virus scanning
of all mail, including quarantining and user/recipient notification of suspect
mail pending further actions, and high level spam filtering - all these things
are almost essential in this day and age. We know of an excellent virus scanner
which beats most of the others hands down, is DLL based for performance, and the
manufacturer does not charge a per user license - so, for example, the hooks
could be integrated with iMS and/or FusionMail (and other WebMails for iMS), and
offered as a module.
The product is Norman Defense Systems which used to be known as the Thunderbyte
Scanner - I used that years ago, and it was the best then even. See:
http://www.norman.com
Spam filtering is something which we can implement at template/SQL level, and I
have defined a possible schema for that already for "per user-user managed" spam
filters, which could be managed through a WebMail interface and switched on/off
and defined at will by the user.
So it is horses for courses - but the more iMS can do, the better it will be.
Adrian Cooper.
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
