I don't know if you meant to include this as part of your first issue
(transaction support), but the last time I checked (several months ago)
MySQL doesn't yet support row-level locking (table level only). This can be
a performance hit on heavily accessed databases.
Still, you couldn't beat the price unless they paid you to use it.
----- Original Message -----
From: "Zachary Bedell" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, February 22, 2001 12:37 PM
Subject: RE: Cheaper Alternative to SQL Server 2000
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> > Well, there's always MySQL, but I bet there's a chorus of
> > folks here who'll
> > say it ain't ready for primetime, which is why I'm posting...
> > could anyone
> > expound on this? Especially using mySQL with CF.
>
> Ok... I'll bite...
>
> Probably the biggest things about MySQL that aren't ready for prime
> time are these:
>
> 1) Its support for transactions is limited (at best!). I know
> they're working on that and it's getting better, but that's a fairly
> big limitation for some situations.
>
> 2) As far as I know, it still doesn't support any kind of stored
> procedure.
>
> 3) They take shortcuts on things like log-before-write that can cause
> data loss or corruption if your server loses power or if MySQL goes
> down hard. Microsoft SQL Server is pretty close to bullet-proof in
> that regard. If SQL Server tells ODBC that data was written, then
> indeed it will be written -- either permanently to the DB or at least
> to the log where it will be recovered if anything unpleasant happens
> to the server. MySQL doesn't do that, so there's a chance of
> problems. I've never run into any, but it's mathematically
> possible....
>
> 4) MySQL's support for JOINs is fairly dumb in my experience. I find
> I have to use completely different syntax to do the same things in
> SQL Server / MS Access then I do for MySQL.
>
>
> That's not to say MySQL doesn't have it's plusses. It *is* free.
> I've got the MP3 player in the trunk of my car running MySQL and it
> works just *fine*. I just wouldn't want to sick a thousand paying
> customers on that server and hope it keeps working through it...
>
> That's just my jaded opinion of course, so please take it with the
> proper grain of salt...
>
> Best regards,
> Zac Bedell
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>
> Comment: Please use PGP!
>
> iQA/AwUBOpVqcKvhLS1aWPxeEQIqvwCg9CPpRT2K4DZyloBKYUDP7JvuTCoAoOxC
> CippPV+adIoyx7ZEQPHH7zqQ
> =YGHK
> -----END PGP SIGNATURE-----
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
