Comparisons between MySQL and SQL Server

Curious to know what solid benchmarks there are out there for MySQL vs. SQL Server.
There is some speculation that my organization might decide to go with MySQL rather than SQL Server -- although I have concerns about the ability of MySQL to scale well -- particularly in a high-volume OLAP type environment.
If anyone can point me to some reviews, studies, that would be great.
Thanks,
Dan
Using what, OLAP4ALL? Which was just released in April?
Anyway, it's going to be tough to find realistic (e.g. not 32-way 8-node
federated databases or beowolf clusters) and unbiased benchmarks.
http://www.eweek.com/article2/0,4149,293,00.asp
http://www.eweek.com/slideshow/0,301...a=23120,00.asp
Also, you can search for information at TPC:
http://www.tpc.org/
http://www.aspfaq.com/
(Reverse address to reply.)
"Dan Carollo" <d.carollo@.verizon.net> wrote in message
news:eKY2nTASEHA.2404@.TK2MSFTNGP09.phx.gbl...
Curious to know what solid benchmarks there are out there for MySQL vs. SQL
Server.
There is some speculation that my organization might decide to go with MySQL
rather than SQL Server -- although I have concerns about the ability of
MySQL to scale well -- particularly in a high-volume OLAP type environment.
If anyone can point me to some reviews, studies, that would be great.
Thanks,
Dan
|||Thanks --
I'm also curious to know if anyone here has worked with MySQL and has a good understanding of how viable a product MySQL is (or is NOT) -- especially in relationship to SQL Server.
I guess it all falls along the same lines as the whole Open-Source debate in general.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message news:OT1A5yASEHA.1216@.TK2MSFTNGP10.phx.gbl...
Using what, OLAP4ALL? Which was just released in April?
Anyway, it's going to be tough to find realistic (e.g. not 32-way 8-node
federated databases or beowolf clusters) and unbiased benchmarks.
http://www.eweek.com/article2/0,4149,293,00.asp
http://www.eweek.com/slideshow/0,301...a=23120,00.asp
Also, you can search for information at TPC:
http://www.tpc.org/
http://www.aspfaq.com/
(Reverse address to reply.)
"Dan Carollo" <d.carollo@.verizon.net> wrote in message
news:eKY2nTASEHA.2404@.TK2MSFTNGP09.phx.gbl...
Curious to know what solid benchmarks there are out there for MySQL vs. SQL
Server.
There is some speculation that my organization might decide to go with MySQL
rather than SQL Server -- although I have concerns about the ability of
MySQL to scale well -- particularly in a high-volume OLAP type environment.
If anyone can point me to some reviews, studies, that would be great.
Thanks,
Dan
|||>> how viable a product MySQL is (or is NOT) -- especially in relationship
to SQL Server.
All depends on your priorities. If you ask 10 different people (not in a
SQL Server forum, mind you), you will get 10 different answers. Asking here
is going to tend to be biased toward SQL Server, simply because of where you
are.
http://www.aspfaq.com/
(Reverse address to reply.)
|||One of the issues the eWeek articles below highlighted was the fact that SQL Server does not perform too well via JDBC -- whereas MySQL performance is superior with JDBC.
However, that article is also 2 years old.
I'm curious to know if these previous issues with JDBC have been resolved in the lastest versions...
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message news:OT1A5yASEHA.1216@.TK2MSFTNGP10.phx.gbl...
Using what, OLAP4ALL? Which was just released in April?
Anyway, it's going to be tough to find realistic (e.g. not 32-way 8-node
federated databases or beowolf clusters) and unbiased benchmarks.
http://www.eweek.com/article2/0,4149,293,00.asp
http://www.eweek.com/slideshow/0,301...a=23120,00.asp
Also, you can search for information at TPC:
http://www.tpc.org/
http://www.aspfaq.com/
(Reverse address to reply.)
"Dan Carollo" <d.carollo@.verizon.net> wrote in message
news:eKY2nTASEHA.2404@.TK2MSFTNGP09.phx.gbl...
Curious to know what solid benchmarks there are out there for MySQL vs. SQL
Server.
There is some speculation that my organization might decide to go with MySQL
rather than SQL Server -- although I have concerns about the ability of
MySQL to scale well -- particularly in a high-volume OLAP type environment.
If anyone can point me to some reviews, studies, that would be great.
Thanks,
Dan
|||You could run a test, if you're already using JDBC and this issue is even
relevant, it shouldn't be difficult to set up a test.
We abandoned JDBC a long time ago, because it was buggy and slow. We still
use SQL Server, but we use other providers to connect. The problems went
away... so I'm not convinced at all that this is even remotely close to an
argument against SQL Server. Do you even use JDBC now? Any plans to do so?
This sounds similar to the OLAP argument... it doesn't even sound like you
have any plans on using OLAP!
I'm debating whether to buy a BMW or a VW Thing. I read an article about
BMWs a few years ago, and it said that they didn't float. So I guess I
better go with the VW Thing, because it floats. Oh, wait, I wasn't planning
on taking the car in the water anyway!
http://www.aspfaq.com/
(Reverse address to reply.)
"Dan Carollo" <d.carollo@.verizon.net> wrote in message
news:e4xDkgMTEHA.3476@.tk2msftngp13.phx.gbl...
One of the issues the eWeek articles below highlighted was the fact that SQL
Server does not perform too well via JDBC -- whereas MySQL performance is
superior with JDBC.
However, that article is also 2 years old.
I'm curious to know if these previous issues with JDBC have been resolved in
the lastest versions...