I think you will find that the latest version of mysql supports transactions
( http://www.mysql.com/news/article-54.html ), we have successfully moved
from sql server 7.0 to mysql 3.23.32, as a side note we also dropped the use
of coldfusion 4.52 and moved to php4.04. this was due to not only the cost
saving gained but the extra stability of a open source non coldfusion
platform.
Hope someone can be helped by the 3 wasted months we had developing for a
platform that is, in effect a rad/demo tool.
Micah.
----- Original Message -----
From: Mark Woods <[EMAIL PROTECTED]>
To: CF-Server <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 11:13 AM
Subject: RE: SQL Server Licensing Confusion -- and best alternative
> IMHO, mySQL is only viable for minor applications, not necessarily because
> of the time taken to learn how to use it (anyone who understands
relational
> database will pick in up in no time), but because it lacks support for
> transactions or stored procedures (though sp support is planned for v4).
> You should be able to use CFLOCK to lock access to the DB to a single
> thread temporarily, effectively creating a transaction, but it's not going
> to be as efficient as having transaction support built into the DBMS.
>
>
> Mark
>
>
>
> At 03:43 PM 3/3/2001, you wrote:
> > MySQL will run on Linux, NT, or Solaris (MAC, DEC, FreeBSD, and
> > AIX also I
> >believe, but not positive). I'm sure someone in your company will know
how
> >to administer at least one of these. I've only used the NT version
> >(comparison here:
>
>http://www.mysql.com/information/benchmark-results/result-mysql-platform-re
l
> >ative.html) and I downloaded some of the free GUI's, and the interface
was
> >easy to use. Not to mention well documented on the web. There will be
some
> >time learning it, but less than you think.
> >
> >-----Original Message-----
> >From: Michiel Boland [mailto:[EMAIL PROTECTED]]
> >Sent: Saturday, March 03, 2001 7:32 AM
> >To: CF-Server
> >Subject: Re: SQL Server Licensing Confusion -- and best alternative
> >
> >
> > > MYSQL. The most used database in the world. It will work for up to
100
> > > Gig. The most it could possibly cost you for a single implementation
is
> > > $200.00. In all likelihood it is free. -Tom
> >
> >You are forgetting the time (=money) it takes to train people to work
with
> >and support MySQL, and the systems on which the database is hosted.
> >
> >Cheers
> >Michiel
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
