What type of SQL is fastest

Hi,

My first post here, so ... excuse me if I don't hit the right jargon.


My question is:

Can anyone give me a good and informative data or source of data ( free ) so I can realy see which SQL "engine" to choose, based on speed, number of options in it... you can even give me the factors I should also take into account.


I tried to find that data - but didn't have much luck.

I already worked with MySQL, and learned the basics of the SQL itself, but I'm interested in performance.



If this is not the right place for this post - mod's and admin's, sorry, please kick it where it should stand.


Thanks Ahead !

There is no one answer to that question. There are too many things that affect the outcomes of the comparisons. Every vendor has published cases where their database outperforms the others, but it's always in very specific comparisons.

For example:

SQL Server Outperforms Oracle in SAP Four-Processor Benchmark: http://www.microsoft.com/sql/evaluat...are/sapad.mspx

More SQL Server comparisons: http://www.microsoft.com/sql/evaluat...e/default.mspx

Unfortunately, MySQL isn't so forthcoming with their own benchmark results any more and seem just happy to play on the fact that they're cheaper.

For my money, I'm sticking with SQL Server.