This is a multi-part message in MIME format.
--=_NextPart_000_00C1_01C447CA.3A6E75A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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
--=_NextPart_000_00C1_01C447CA.3A6E75A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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
--=_NextPart_000_00C1_01C447CA.3A6E75A0--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,3018,sid=0&s=1590&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|||This is a multi-part message in MIME format.
--=_NextPart_000_00B2_01C448B1.84004D00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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,3018,sid=3D0&s=3D1590&a=3D23120,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
--=_NextPart_000_00B2_01C448B1.84004D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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]"
=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-nodefederated databases or beowolf clusters) and unbiased benchmarks.http://www.eweek.com/article2/0,4149,293,00.asp">http://www.eweek=.com/article2/0,4149,293,00.asphttp://www.eweek.com/slideshow/0,3018,sid=3D0&s=3D1590&=amp;a=3D23120,00.aspAlso, you can search for information at TPC:http://www.tpc.org/">http://www.tpc.org/-- http://www.aspfaq.com/">http://www.aspfaq.com/(Reverse =address to reply.)"Dan Carollo" =wrote in messagenews:eKY2nTASEHA.2404=@.TK2MSFTNGP09.phx.gbl...Curious to know what solid benchmarks there are out there for MySQL vs. SQLServer.There is some speculation that my organization might =decide to go with MySQLrather than SQL Server -- although I have =concerns about the ability ofMySQL 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
--=_NextPart_000_00B2_01C448B1.84004D00--|||>> 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.)|||This is a multi-part message in MIME format.
--=_NextPart_000_001D_01C44C8D.76A4FB80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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,3018,sid=3D0&s=3D1590&a=3D23120,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
--=_NextPart_000_001D_01C44C8D.76A4FB80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
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]" =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-nodefederated databases or beowolf clusters) and unbiased benchmarks.http://www.eweek.com/article2/0,4149,293,00.asp">http://www.eweek=.com/article2/0,4149,293,00.asphttp://www.eweek.com/slideshow/0,3018,sid=3D0&s=3D1590&=amp;a=3D23120,00.aspAlso, you can search for information at TPC:http://www.tpc.org/">http://www.tpc.org/-- http://www.aspfaq.com/">http://www.aspfaq.com/(Reverse =address to reply.)"Dan Carollo" =wrote in messagenews:eKY2nTASEHA.2404=@.TK2MSFTNGP09.phx.gbl...Curious to know what solid benchmarks there are out there for MySQL vs. SQLServer.There is some speculation that my organization might =decide to go with MySQLrather than SQL Server -- although I have =concerns about the ability ofMySQL 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
--=_NextPart_000_001D_01C44C8D.76A4FB80--|||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...
