I'm kinda jumping into the middle of this thread but I thought it would be worth mentioning that I've had exceptionally good experiences with PostgreSQL. It's licensed even more liberally then MySQL, and is regularly benchmarked at being faster with complex queries then MySQL is.
I started using PostgreSQL back in the days of MySQL 3, before MySQL supported simple things like sub-queries. That was incredibly frustrating at the time, and PostgreSQL fixed me right up with a free, fast, functional, open-source solution. It's worth a look if you're still open to the idea of open-source solutions. Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider David McGuigan wrote: > I'm not against open source in any way shape or form! SOME of it is > fantastic. But that doesn't mean I think that all open source products are > great or even decent. Honestly it seems like a lot of them are pretty > fruitless, and more the personal hobbies and indulgences of the developers > than useful bits of software ( read: a few of my own open source projects > that luckily never even went public ; ). MySQL obviously not included. > I adopted Firefox literally the moment I discovered tabbed browsing back > before IE had it and when any product ( open source or otherwise ) is good > enough, I evangelize it like a Jehova's Witness ( that's a compliment, it's > pretty impressive that they hit the streets on Saturdays just to spread some > church ). > > Like I said, I've loved and used MySQL for years, and am only now unlocking > its deep, dirty secrets. Clearly, it can do plenty of things very well or > well enough. So it's great ( or fine ) for a lot of projects / operations. > Unfortunately, for the stuff I was doing, it really really struggled ( and > was obliterated in comparative performance by SQL Server 2008 ). > Unfortunately ( sorry Judah ), I can't go very deeply into the explicit > details of what MySQL was struggling with because our implementation is > pretty tightly bound to some closed-sourcey commercial / intellectual > property even at the database level. > > I can say that generally speaking some general issues that MySQL exhibited > were the inability to correctly determine its own best execution plans, > leverage precisely-defined indexes even when explicitly directed to with > SQL-level overrides, correctly negotiate certain types of subqueries and not > do more work than it needed to ( which was pretty ridiculous, at one point > we were using ColdFusion to mitigate MySQL's own self-inflicted overload by > feeding simulated subquery results to other queries as parameters by > relaying the results to and from CF ), and reliably join to the same table( > s ) multiple times against different subsets of its data to create highly > dynamic temporary composites. Its raw view performance was also pretty weak > at a real scale. Another thing to mention ( since you mention the storage > engine implementation in MySQL ) is that the issues we had were almost > exclusively with the InnoDB storage engine ( the most popular transactional > engine with support for foreign key cascades ), and we used a design that > was very driven by automated referential integrity with foreign and > composite keys, which some people see as a more contemporary, cutting-edgey > approach. After our complete re-architecture ( which now relies on > application-server management of most of the things we tried to let MySQL > handle automatically ) and a mostly MyISAM table design, MySQL is performing > much, much better. > > > > > On Sun, Sep 6, 2009 at 3:17 PM, Jochem van Dieten <joch...@gmail.com> wrote: > >> On Sat, Sep 5, 2009 at 1:40 PM, David McGuigan wrote: >>>> Companies use open source ( and free ) software for a variety of >> reasons. >>>> Usually out of either stubbornness or a genetic allergy to Microsoft. >>> Most of the other Google apps though have seemed really slow to me ( and >>> been down completely more times than I can count on one hand ). I use >> Gmail, >>> Calendar, their Spreadsheet/Docs, IM, etc. And the only app I've ever >> really >>> been impressed with of theirs is Chrome ( which is my favorite browser ). >> You use Chrome? So are you stubborn or allergic? >> >> Jochem >> >> >> -- >> Jochem van Dieten >> http://jochem.vandieten.net/ >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326071 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
