. thanks for the info. this sounds like a way to go.
At 07:03 p.m. 28/07/00 -0400, you wrote:
>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/
********************************************
* 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/
�����������������������==
