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