views:

66

answers:

2

Any good articles out there comparing Oracle vs SQL Server vs MySql in terms of performance?

I'd like to know things like:

  • INSERT performance
  • SELECT performance
  • Scalability under heavy load

Based on some real examples in order to gain a better understanding about the different RDBMS.

+3  A: 

The question is really too broad to be answered because it all depends on what you want to do as there is no general "X is better than Y" benchmark without qualifying "at doing Z" or otherwise giving it some kind of context.

The short answer is: it really doesn't matter. Any of those will be fast enough for your needs. I can say that with 99% certainty. Even MySQL can scale to billions of rows.

That being said, they do vary. As just one example, I wrote a post about a very narrow piece of functionality: join and aggregation performance. See Oracle vs MySQL vs SQL Server: Aggregation vs Joins.

cletus
I guess that's what I said in my comment, but I just didn't say it as well!
Mitch Wheat
I'm looking for links to actual benchmarks. Just that.
pablo
A: 

Yes, such benchmarks do exist, but they cannot be published, as Oracle's licensing prohibits publishing such things.

At least, that is the case to the best of my knowledge. I've seen a few published which do not name Oracle specifically, but instead say something like "a leading RDBMS" when they are clearly talking about Oracle, but I don't know whether that gets around it.

On the other hand, Oracle now own MySQL, so perhaps they won't care so much, or perhaps they will. Who knows.

MarkR