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-rel
>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
