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:

  • Which is a better method for storing images - folder or SQL Server as binary?
  • Converting Oracle code to SQL Server for a fixture list
  • Computed column expression
  • How to export query results to csv in Microsoft SQL Server Management Studio?
  • SQL - Turn relationship IDs into a delimited list
  • Parse a date from unformatted text in SQL
    • INSERT performance
    • SELECT performance
    • Scalability under heavy load

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

  • Variables scope which are defined within a while block in stored procedures - SQl Server
  • Quickest/Easiest way to use Search/Replace through all stored procedures
  • How to get the client IP address from SQL Server 2008 itself?
  • SQL Server 2008 - HashBytes computed column
  • Script all views/functions/procedures in a Sql Server database in dependency order
  • SQL Server: What are ODBC canonical functions?
  • 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.