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...
Showing posts with label comparisons. Show all posts
Showing posts with label comparisons. Show all posts
Sunday, February 12, 2012
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 My
SQL 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,
DanUsing 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,30...&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 i
n 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,30...&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,30...&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...
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 My
SQL 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,
DanUsing 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,30...&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 i
n 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,30...&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,30...&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...
Comparisons between MySQL and SQL Server
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...
--=_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]"
--=_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]"
--=_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...
Comparison on SQL Server 2000 and SQL Server 2005
Hi all,
I would like to ask if any research conducted on comparisons of SQL Server 2000 and SQL Server 2005? If yes, where can I find them?
Thanks a lot!
Gabriel
That's a pretty open-ended question! This web page lists a bunch of info on SQL Server 2005.
http://www.microsoft.com/sql/prodinfo/news.mspx
If you still have specific questions after reading everything there 
Paul
Friday, February 10, 2012
Comparison between SQL 2000 and Progress db
Hello,
I have used both, if its the Progress I'm thinking of.=20
Firstly I don't believe that there are any comparisons for=20
Progress its too niche. As a database its ok, you have all=20
the normal columns, foriegn keys relationships. From a DBA=20
point of view its a bit of a pain as you don't have the=20
tools as you do in SQL server or Oracle. A good example is=20
that we have a 1 gb production database that can only be=20
backed up once an hour, and it needs to be a total backup,=20
rather than say a transactional backup.
Transfering data from progress to Window Application is a=20
pain, mainly due to the Progress Application we use are=20
all Unix based so we have to write to a text file. There=20
is an ODBC tie into Progress but its an extra, I believe=20
that it costs =A310k +.
Progress itself is both a Database and Application=20
package, i.e. the code works seemlessly with the database.=20
The progress sql is different to T-SQL and PL-SQL so you=20
will be relearning SQL if you were to get it.=20
Finally you might want to look at recruitment, we have=20
activly been recruiting Progress programmers for some time=20
and cannot find them, as opposed to SQL Server and Oracle=20
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing=20
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as=20
a database?
>Positive or negative.
>We are busy with a evaluation of various software=20
products, and one of the
>products use a progress database, the other 2 is oracle=20
and sql2000.
>My biggest concerns is the application using the progress=20
database, as I am
>not a progress developer, or do I have any knowledge=20
about the product.
>Can anybody give me more information, personal=20
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs 10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
I have used both, if its the Progress I'm thinking of.=20
Firstly I don't believe that there are any comparisons for=20
Progress its too niche. As a database its ok, you have all=20
the normal columns, foriegn keys relationships. From a DBA=20
point of view its a bit of a pain as you don't have the=20
tools as you do in SQL server or Oracle. A good example is=20
that we have a 1 gb production database that can only be=20
backed up once an hour, and it needs to be a total backup,=20
rather than say a transactional backup.
Transfering data from progress to Window Application is a=20
pain, mainly due to the Progress Application we use are=20
all Unix based so we have to write to a text file. There=20
is an ODBC tie into Progress but its an extra, I believe=20
that it costs =A310k +.
Progress itself is both a Database and Application=20
package, i.e. the code works seemlessly with the database.=20
The progress sql is different to T-SQL and PL-SQL so you=20
will be relearning SQL if you were to get it.=20
Finally you might want to look at recruitment, we have=20
activly been recruiting Progress programmers for some time=20
and cannot find them, as opposed to SQL Server and Oracle=20
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing=20
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as=20
a database?
>Positive or negative.
>We are busy with a evaluation of various software=20
products, and one of the
>products use a progress database, the other 2 is oracle=20
and sql2000.
>My biggest concerns is the application using the progress=20
database, as I am
>not a progress developer, or do I have any knowledge=20
about the product.
>Can anybody give me more information, personal=20
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs 10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Comparison between SQL 2000 and Progress db
Hi
Does anybody know of any comparisons or benchmark testing done on SQL 2000
and Progress.?
Also does anybody have any comments on using Progress as a database?
Positive or negative.
We are busy with a evaluation of various software products, and one of the
products use a progress database, the other 2 is oracle and sql2000.
My biggest concerns is the application using the progress database, as I am
not a progress developer, or do I have any knowledge about the product.
Can anybody give me more information, personal experience, or point me to a
web site with relevant information.
Thank youHello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for Progress its too niche. As a database its ok, you have all the normal columns, foriegn keys relationships. From a DBA point of view its a bit of a pain as you don't have the tools as you do in SQL server or Oracle. A good example is that we have a 1 gb production database that can only be backed up once an hour, and it needs to be a total backup, rather than say a transactional backup.
Transfering data from progress to Window Application is a pain, mainly due to the Progress Application we use are all Unix based so we have to write to a text file. There is an ODBC tie into Progress but its an extra, I believe that it costs =A310k +.
Progress itself is both a Database and Application package, i.e. the code works seemlessly with the database. The progress sql is different to T-SQL and PL-SQL so you will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have activly been recruiting Progress programmers for some time and cannot find them, as opposed to SQL Server and Oracle where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as a database?
>Positive or negative.
>We are busy with a evaluation of various software products, and one of the
>products use a progress database, the other 2 is oracle and sql2000.
>My biggest concerns is the application using the progress database, as I am
>not a progress developer, or do I have any knowledge about the product.
>Can anybody give me more information, personal experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>|||Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs £10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Does anybody know of any comparisons or benchmark testing done on SQL 2000
and Progress.?
Also does anybody have any comments on using Progress as a database?
Positive or negative.
We are busy with a evaluation of various software products, and one of the
products use a progress database, the other 2 is oracle and sql2000.
My biggest concerns is the application using the progress database, as I am
not a progress developer, or do I have any knowledge about the product.
Can anybody give me more information, personal experience, or point me to a
web site with relevant information.
Thank youHello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for Progress its too niche. As a database its ok, you have all the normal columns, foriegn keys relationships. From a DBA point of view its a bit of a pain as you don't have the tools as you do in SQL server or Oracle. A good example is that we have a 1 gb production database that can only be backed up once an hour, and it needs to be a total backup, rather than say a transactional backup.
Transfering data from progress to Window Application is a pain, mainly due to the Progress Application we use are all Unix based so we have to write to a text file. There is an ODBC tie into Progress but its an extra, I believe that it costs =A310k +.
Progress itself is both a Database and Application package, i.e. the code works seemlessly with the database. The progress sql is different to T-SQL and PL-SQL so you will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have activly been recruiting Progress programmers for some time and cannot find them, as opposed to SQL Server and Oracle where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as a database?
>Positive or negative.
>We are busy with a evaluation of various software products, and one of the
>products use a progress database, the other 2 is oracle and sql2000.
>My biggest concerns is the application using the progress database, as I am
>not a progress developer, or do I have any knowledge about the product.
>Can anybody give me more information, personal experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>|||Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs £10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Comparison between SQL 2000 and Progress db
Hello,
I have used both, if its the Progress I'm thinking of.=20
Firstly I don't believe that there are any comparisons for=20
Progress its too niche. As a database its ok, you have all=20
the normal columns, foriegn keys relationships. From a DBA=20
point of view its a bit of a pain as you don't have the=20
tools as you do in SQL server or Oracle. A good example is=20
that we have a 1 gb production database that can only be=20
backed up once an hour, and it needs to be a total backup,=20
rather than say a transactional backup.
Transfering data from progress to Window Application is a=20
pain, mainly due to the Progress Application we use are=20
all Unix based so we have to write to a text file. There=20
is an ODBC tie into Progress but its an extra, I believe=20
that it costs =A310k +.
Progress itself is both a Database and Application=20
package, i.e. the code works seemlessly with the database.=20
The progress sql is different to T-SQL and PL-SQL so you=20
will be relearning SQL if you were to get it.=20
Finally you might want to look at recruitment, we have=20
activly been recruiting Progress programmers for some time=20
and cannot find them, as opposed to SQL Server and Oracle=20
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing=20
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as=20
a database?
>Positive or negative.
>We are busy with a evaluation of various software=20
products, and one of the
>products use a progress database, the other 2 is oracle=20
and sql2000.
>My biggest concerns is the application using the progress=20
database, as I am
>not a progress developer, or do I have any knowledge=20
about the product.
>Can anybody give me more information, personal=20
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs 10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
I have used both, if its the Progress I'm thinking of.=20
Firstly I don't believe that there are any comparisons for=20
Progress its too niche. As a database its ok, you have all=20
the normal columns, foriegn keys relationships. From a DBA=20
point of view its a bit of a pain as you don't have the=20
tools as you do in SQL server or Oracle. A good example is=20
that we have a 1 gb production database that can only be=20
backed up once an hour, and it needs to be a total backup,=20
rather than say a transactional backup.
Transfering data from progress to Window Application is a=20
pain, mainly due to the Progress Application we use are=20
all Unix based so we have to write to a text file. There=20
is an ODBC tie into Progress but its an extra, I believe=20
that it costs =A310k +.
Progress itself is both a Database and Application=20
package, i.e. the code works seemlessly with the database.=20
The progress sql is different to T-SQL and PL-SQL so you=20
will be relearning SQL if you were to get it.=20
Finally you might want to look at recruitment, we have=20
activly been recruiting Progress programmers for some time=20
and cannot find them, as opposed to SQL Server and Oracle=20
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing=20
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as=20
a database?
>Positive or negative.
>We are busy with a evaluation of various software=20
products, and one of the
>products use a progress database, the other 2 is oracle=20
and sql2000.
>My biggest concerns is the application using the progress=20
database, as I am
>not a progress developer, or do I have any knowledge=20
about the product.
>Can anybody give me more information, personal=20
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>Thanks for your post Peter.
I appreciate and value your comments.
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:922201c43359$934a6a10$a601280a@.phx.gbl...
Hello,
I have used both, if its the Progress I'm thinking of.
Firstly I don't believe that there are any comparisons for
Progress its too niche. As a database its ok, you have all
the normal columns, foriegn keys relationships. From a DBA
point of view its a bit of a pain as you don't have the
tools as you do in SQL server or Oracle. A good example is
that we have a 1 gb production database that can only be
backed up once an hour, and it needs to be a total backup,
rather than say a transactional backup.
Transfering data from progress to Window Application is a
pain, mainly due to the Progress Application we use are
all Unix based so we have to write to a text file. There
is an ODBC tie into Progress but its an extra, I believe
that it costs 10k +.
Progress itself is both a Database and Application
package, i.e. the code works seemlessly with the database.
The progress sql is different to T-SQL and PL-SQL so you
will be relearning SQL if you were to get it.
Finally you might want to look at recruitment, we have
activly been recruiting Progress programmers for some time
and cannot find them, as opposed to SQL Server and Oracle
where we can normally find someone in about three months.
Peter
>--Original Message--
>Hi
>Does anybody know of any comparisons or benchmark testing
done on SQL 2000
>and Progress.?
>Also does anybody have any comments on using Progress as
a database?
>Positive or negative.
>We are busy with a evaluation of various software
products, and one of the
>products use a progress database, the other 2 is oracle
and sql2000.
>My biggest concerns is the application using the progress
database, as I am
>not a progress developer, or do I have any knowledge
about the product.
>Can anybody give me more information, personal
experience, or point me to a
>web site with relevant information.
>Thank you
>
>.
>
Subscribe to:
Posts (Atom)