It seems to me that you should be able to store messages in the
SQL database without having to use blobs or other Binary field
types since SMTP mail is text only by it's very nature. If you want
to keep the attachments in the SQL database then just don't
decode the raw MIME until you need it.
The only potential problem I see is with ODBC's limitation of only
64K bytes in a text field. You would have to set up CF to use the
native drivers for the database rather than the ODBC shim.
-Chris
my 2�
> Not sure if you know MailMax Mail server? its a mail server from smartmax
> soft.. Some months ago I got in touch with this company and got a beta
> version of MailMax for SQL, they try to make the mail server storing data
> on db but aborted the experiment because of the delay on accessing this
> kind of data, this guys are really good working on MS data bases. I would
> like to make some test about this to see it by my self but I will start
> from the very beginning since I have never store other info than text on
> sql db (no experience on binary data).. and as far as I know there is no
> docs on cf on how to insert or decode.
>
> At 11:27 p.m. 28/07/00 +0100, you wrote:
>
> > > >
> > >
> > > Thanks kim will be very careful :) hope to get it done successfully. This
> > > will really make things better if we can make it..
> >
> >Yes - I agree entirely! SQL Server based message storage is the key to
> >unlimited possibilities, which we have discussed before,and likely will again.
> >
> >To me - there is no doubt whatsoever that_all_mail should go straight to a SQL
> >Server and should be managed and retrieved through a SQL Server - that
> >much is a
> >no brainer - my only residual concern, and not one that has any basis in fact
> >yet - is message handling performance compared to plain text files. It is
> >possible of course that SQL based messaging might offer even better
> >performance
> >due to the processing power of SQL server itself. Nevertheless - I
> >would_really_like to see this done effectively.
> >
> >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/
> >========================================================================
>
>
>
> ********************************************
> * Ing. Guillermo Dewey Guerra
> * Metro Cybercomercio Mexico
> * [EMAIL PROTECTED]
> * ICQ: 25876549 (GDewey)
> *
> * http://www.metro.com.mx
> * http://www.ablecommerce.com.mx
> *
> * Tel. (011) (52) (8) 3-90-7000
> * Fax (011) (52) (8) 3-90-7001
> * Cel. (011) (52) (044) (8) 3-09-24-16
> * Monterrey N.L. Mexico
> ********************************************
>
>
> ========================================================================
> 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/
> ========================================================================
>
-----BEGIN GEEK CODE BLOCK-----
Version: 3.12
GCS/IT/MU d- s:++>: a- C++++()$ P+ L+>+++ W++(--) N w++(--)
!O !M PS+ PE(++) Y+ PGP++ t+ 5- X+ R(+) tv b+>+++ D+++() G e
h--(*) !r !y->+++
------END GEEK CODE BLOCK------
������������������������ 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/
�����������������������==
