Database performance benchmark

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

I’d like to know things like:

  • TSQL XQuery to obtain two child nodes
  • Sql Server CE 3.5 Merge Replication Synchronise is Hanging
  • Service Broker messages not being sent if target rebooted
  • How to make a link between what was inserted and where it came from
  • Remove space recursively in string
  • Mantis cannot connect to SQL Server
    • INSERT performance
    • SELECT performance
    • Scalability under heavy load

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

  • SQL query where clause for reporting
  • MS SQL - MySQL - Openquery Chinese characters imported as '?'
  • Invalid use side-effecting operator Insert within a function
  • Login failed for user sql
  • Count Values from Table for each type
  • Update value on insert into table in SQL Server
  • 2 Solutions collect form web for “Database performance benchmark”

    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.

    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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.