.16 seconds in 2009 is the equivalent of ~20 minutes in 1990's time. I'm kind of kidding. But are we sure that Google's search ( which is probably its best performing software ) uses MySQL anyway? I thought it used BigTable or whatev ( http://labs.google.com/papers/bigtable.html )
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 ). I actually really like SQLYog ( save the logo ) and use it in combination with Navicat and MySQL Query Browser ( each one does a few things well, other things horribly, so I alternate for specific tasks ). But once you get into some less-common, complex-ier shiz it struggles pretty badly. Trying to edit compound views derived from composite alphanumeric keys was a total fail for example. The SQL it generated under the hood ( which you can inspect in the history tab, a feature I love ), was totally wrong and would error if I was lucky ( and if not just execute incorrect operations against the d.b. ). But anyway, just as a quick anecdote. In the last few months I have been able to repeatedly, accidentally drop MySQL to its knees with what I'd consider to be basic ( though highly dynamic ), clean, structurally sound database designs and not-that-fancy querying. Even taking a scalpel and microscope and patching every gap with highly designed indexes and directives to MySQL to use them on even an SQL level couldn't make it do what it should and perform even acceptably in certain cases. Popping the exact same tables, data, and SQL into an SQL Server 2008 instance? Instantly, from the very first execution took operations that were taking 15-120 full seconds to execute down to < 5 MILLISECONDS. WITHOUT EVEN ADDING ONE MANUAL INDEX AT ALL. That knocked my socks off, and was how I would've expected any modern database system to perform with what I was doing before the MySQL struggle. Granted, there are some things MySQL does plenty well, but scattered all around the feature set are bugs and land mines waiting to go off in your application or development that may or may not affect you depending on what your application does. And you either need the luxury of an infinite amount of time to throw rocks and try to discover and pick off all of the triggers, or to hire a bomb expert last minute ( which I would bet money that most of the high-scale companies that went with MySQL end up doing, which is how it makes its money ) to come in and fix everything and divvy you the hacks and secrets at the rate of 8 million dollars per minute of "support". Up until I started developing an application that needed to support thousands of concurrent users with real, instajax performance I'd loved MySQL and never seen any reason to even check out other options. It was free, the IDEs worked well enough, and it seemed pretty popular. But when I did. And development came to a standstill... And I found myself doing more scavenger hunting, experimentation, and research than coding... just to make the software perform its sole function acceptably... everything changed. What a waste of my time. Now I kind of see SQL Server the same way I see ColdFusion. You pay for it because it's better. It saves you time. It lets you focus on what you should be focusing on and producing great applications. Total ROI. This whole thread has actually gotten me kind of excited to move to SQL Server. So thanks Billy! PS Gerald I think we should write our congressman and get America to adopt a new standard unit of measurement of time. I would much rather measure everything in blips than seconds. On Fri, Sep 4, 2009 at 9:30 PM, Gerald Guido <[email protected]> wrote: > > > > > 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. > > > > Searching for the letter "a" on google. > > "Results *1* - *100* of about *17,790,000,000* for *a*. (*0.16* seconds) " > > But yeah.... That isn't a MySLQ query. Gmail can be sluggish but I think it > is more of a JS engine issue more than anything else. > > > Better IDE and tools ( the MySQL enterprise tools, at least the ones I've > > used, are all but a joke ). > > > > > The MySQL software bundle is pretty crappy. I stopped using them years ago. > I was never able to get the migration tools to work right. > > However, SQLyog, Toad for MySQL and the EMS tools rock IMHO. > > >> a genetic allergy to Microsoft. > > Now that is funny. > > But yeah, I moved to MySQL cuz it was free and I was a freelancer at the > time. $5k is a lot of beer and donuts. > > But at the same time, I have been able to do things with DTS and SSIS that > are pretty stunning. Like import a 25 meg MLS XML file in what I can only > describe as being a blip. That was in 2003 though. I haven't looked at > MySQL's tool set in that respect since then. > > G! > > > -- > Gerald Guido > http://www.myinternetisbroken.com > > "To invent, you need a good imagination and a pile of junk." > -- Thomas A. Edison > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:326033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
