Which database to pick is always a tough question. There are many people
who will just choose a database based on personal preference. You need to
look at your application and your wallet and chose the best fit.
I think Allaire is right on with their comment on Access, but certainly not
MySQL. MySQL will work fine for "real applications" as long as it is the
best tool or at least the best tool for the money.
Generally speaking I only use Oracle and SQL Server. Oracle is great for
portability and scalability. From a developers point of view SQL Server is
a dream to work with. SQL Server also offers some of the best full text
searching you can find. However, it only runs on Windows and isn't all that
scalable. When it comes to the performance needs of web applications all of
the available databases do pretty well. The commercial databases all offer
native drivers which have big performance advantages over ODBC.
-Matt
> -----Original Message-----
> From: Tim Storm [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 29, 2000 6:37 PM
> To: CF-Linux
> Subject: Re: CF-Linux-List V1 #25
>
>
> Jason, Matt et al -
>
> I for one thank you for your involvement on this list. I've
> learned from
> all of you.
>
> I personally like the MySQL talk and how it relates to CF
> Linux performance.
> I'm a MySQL user, and basically selected it for price and availability
> reasons. As an "up and coming" website going through constant growing
> pains, I only wonder how long MySQL will hold up before it
> breaks! I know
> that I've had comments from Allaire regarding MySQL and how
> it is similar to
> Access - Good for prototyping, but not for "real applications".
>
> So far the problems that I've had centered around the Merant
> MySQL driver,
> and CF, but not MySQL itself. (Kind of makes me wonder if
> Allaire should be
> throwing stones!?)
>
> All verbal jabs and personal preferences aside - if anyone
> has a db solution
> better than MySQL in terms of reliability (remember I've had
> no problems
> with MySQL itself), Performance (please provide head to head
> examples) or
> TCO - I WOULD LOVE TO HEAR ABOUT IT!
>
> Thanks All!
>
> Tim Storm
> FatWallet.Com (A tiny little website that just might!)
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
