John Paul Ashenfelter wrote: > > PERFORMANCE IS POOR? Yes it is :-) For one of my applications at least, MySQL's inability to scan indexes in both directions quite literally kills it (who cares that MySQL is 2 times faster on 80% of the queries, when it is 200 times slower on the rest).
On the other hand, we have people that get great performance from MySQL: > http://www.eweek.com/article2/0,3959,293,00.asp So the conclusion is the same as always: There is no point in trusting somebody elses benchmarks (not even mine :-), you need to run your own benchmarks, designed for your own application and with your own dataset. <OT> > Their PHP manager What did he have to say about PHP switching from MySQL to SQLLite? </OT> > But don't > discount MySQL out of hand. Or PostgreSQL, but thats a completely different > story and I'm sure Jochem is a better source for that than me :) The story is the same as always: every application is different BTW, I am convinced that if you take out the "nobody ever got fired for buying Oracle" factor for people solliciting information about databases on this list, it pretty much becomes "nobody ever buys Oracle". (Not because Oracle isn't great (it is), but because when you really need the features you should have a DBA to make that decision for you instead of sollicit opinions on this list.) Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137619 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
