There are about 1,000 reasons I can think of, but I only have limited experience with SQL Server ( just enough to observe these differences ): Less administration and maintenance. Less tuning necessary for pureformance. Exponentially superior performance out of the box. A single, superhero storage engine ( which itself has about 1,000 other benefits IMO ). Way more stable. Better IDE and tools ( the MySQL enterprise tools, at least the ones I've used, are all but a joke ). Significantly lower total cost of ownership for teams and companies without expert MySQL in-house knowledge that know how to solve all of MySQL's shortcomings without investing a lot of time in research and scavenger hunting ).
Companies use open source ( and free ) software for a variety of reasons. Usually out of either stubbornness or a genetic allergy to Microsoft. Out of the companies you listed, I've only ever used Facebook, Flickr, Google, eBay, iStockPhoto, Ticketmaster, and Yahoo. I'm not saying this is a litmus test, but with the exception of maybe Yahoo ( but I haven't really used Yahoo THAT much ), I have always consciously THOUGHT as I used every single one of those other sites that their performance was pretty lackluster. Obviously we can only speculate as to what their bottlenecks are/were, how much a factor their scale actually is, etc, but I have felt, and noticed myself feeling, very disappointed with their software performance. Clearly MySQL is to blame ( kidding ). On Fri, Sep 4, 2009 at 7:48 PM, Andrew Grosset <rushg...@yahoo.com> wrote: > > >Yes the proc license is really the only way to go... The difficulty in > >switching depends greatly on your code. IT could be quite easy - or > require > >rewriting every query. > > > >I recently helped a customer go from MySQL to MSSQL and I wrote a couple > of > >posts on it. It will give you an idea of the type of difficulty you might > >encounter. > > > >http://www.coldfusionmuse.com/index.cfm/2009/7/13/MySQL.to.MSSQL > > > > > http://www.coldfusionmuse.com/index.cfm/2009/7/23/data.truncation.mysql.to.m > >ssql > > > >I recently helped a customer go from MySQL to MSSQL and I wrote a couple > of > >posts on it. It will give you an idea of the type of difficulty you might > >encounter. > > > > curious as to why anyone would want to switch from MySQL to MSSQL...... > > a quick look at mysql.com/customers showed the following: > > facebook > feedster > flickr > fotolog > > and that was just in "f" > > also found craigslist, ebay, Google, istockphoto, ticketmaster, webtrends, > yahoo and the list goes on and on....... > > I found the switch fairly easy, definitely worth a look as its free to > download. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
