ORACLE VS MS SQL Server
-
I would like to debate the pros and cons of Ms SQL Server vs. Oracle purely from a performance and Size scale for an enterprise based system. Yes I know with .NET you will loose the LINQ productivity advantage and so on. But lets say for argument sake I am using C# as my language for an IIS 7 hosted solution Which one will come out on top as far as Speed, Size and amount of concurrent connections it can handle. Also upgradability from a (Hard drives are getting full) point of view Any advice from hands on experience would be ideal.
Chona1171 Web Developer (C#), Silverlight
-
I would like to debate the pros and cons of Ms SQL Server vs. Oracle purely from a performance and Size scale for an enterprise based system. Yes I know with .NET you will loose the LINQ productivity advantage and so on. But lets say for argument sake I am using C# as my language for an IIS 7 hosted solution Which one will come out on top as far as Speed, Size and amount of concurrent connections it can handle. Also upgradability from a (Hard drives are getting full) point of view Any advice from hands on experience would be ideal.
Chona1171 Web Developer (C#), Silverlight
It's horses for courses. SQL Server is probably marginally better in a Windows OS platform, who'd a thunk it. However if you are looking at high end with dedicated servers, Oracle will out perform SQL Server.
Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
-
I would like to debate the pros and cons of Ms SQL Server vs. Oracle purely from a performance and Size scale for an enterprise based system. Yes I know with .NET you will loose the LINQ productivity advantage and so on. But lets say for argument sake I am using C# as my language for an IIS 7 hosted solution Which one will come out on top as far as Speed, Size and amount of concurrent connections it can handle. Also upgradability from a (Hard drives are getting full) point of view Any advice from hands on experience would be ideal.
Chona1171 Web Developer (C#), Silverlight
I think first the foundation shall be chosed and then the decisions will be build from groupd up. Obviously if you choose that C# (.NET variants) then it performs better with MSSQL. But consider generic platforms say C++/Php/Ruby,etc languages in a large scale. Then you would see the bigger picture. Most of the complex, high end apps i have seen prefer to use Oracle.
-
I would like to debate the pros and cons of Ms SQL Server vs. Oracle purely from a performance and Size scale for an enterprise based system. Yes I know with .NET you will loose the LINQ productivity advantage and so on. But lets say for argument sake I am using C# as my language for an IIS 7 hosted solution Which one will come out on top as far as Speed, Size and amount of concurrent connections it can handle. Also upgradability from a (Hard drives are getting full) point of view Any advice from hands on experience would be ideal.
Chona1171 Web Developer (C#), Silverlight
The main problem I've seen with Oracle is the licensing scheme. Where I am now we mostly use SQL Server and that appears to be the preferred choice for the scale of project I'm working on, but I also have to connect to some Oracle and MySQL databases within the company.
Chona1171 wrote:
will loose the LINQ
I don't use that, but I thought it worked with any database with a .net connector (including Oracle and MySQL).