13-01-2008, 07:07 PM
Spodi Wrote:If it was that clear, you wouldn't see them still circulating, would you? MySQL definitely dominates on accessibility and ease of implementation, so for people to use other ones... there must be a reason, right?
Just switching databases isn't a valid test in the slightest unless you are testing that specific query, which is not often the case as you often only care about the answer, not the question. On a very basic level, one database may perform "SELECT * ..." faster than "SELECT name ..." when all you need is "name". This means one is going to remain unoptimized with that query, which means your programming is biased towards one test and not the other.
MySQL is far from bad, I am not saying it is bad nor even the best option in many cases, but there are times where others perform better. Your experiences may tell you otherwise, which isn't something to be unexpected, but you can't just assume that just because of this one instance, MySQL is hands-down the best. For this case, in this database setup, using these queries - yes, you found out it is best. Thats it. Best, for that case.
So BT uses MySQL. Know who uses MSSQL? Oh gee, maybe Microsoft? Oracle? Amazon.com. But I guess these people don't have big enough sites... oh no wait, scratch that. I guess they just don't know what they're doing and have never tested the other databases since I doubt its part of their job or even small differences can save or cost tens of thousands of dollars, if not more, for the company. Yup, definitely can't be it.
Statistics, facts, whatever - it means nothing to me. I work with this all day, 5 days a week; if you think you know better than grats, but srsly, mysql or nothing.