Hello everyone,
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin Par
Microsoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Co..._vs_oracle.htm
http://www.microsoft.com/sql/evaluat...benchmarks.asp
http://searchdatabase.techtarget.com...953120,00.html
http://www.oracle.com/technology/pro...0g-vs-ss2k.pdf
David G.
|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>
Showing posts with label benchmarks. Show all posts
Showing posts with label benchmarks. Show all posts
Tuesday, March 20, 2012
Performance benchmarks
Labels:
benchmark,
benchmarks,
compare,
cons,
database,
databaseengines,
microsoft,
mysql,
oracle,
performance,
pros,
server,
sql
Performance benchmarks
Hello everyone,
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin Par
Microsoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Co..._vs_oracle.htm
http://www.microsoft.com/sql/evaluat...benchmarks.asp
http://searchdatabase.techtarget.com...953120,00.html
http://www.oracle.com/technology/pro...0g-vs-ss2k.pdf
David G.
|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin Par
Microsoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Co..._vs_oracle.htm
http://www.microsoft.com/sql/evaluat...benchmarks.asp
http://searchdatabase.techtarget.com...953120,00.html
http://www.oracle.com/technology/pro...0g-vs-ss2k.pdf
David G.
|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>
Labels:
benchmark,
benchmarks,
compare,
cons,
database,
databaseengines,
microsoft,
mysql,
oracle,
performance,
pros,
server,
sql
Performance benchmarks
Hello everyone,
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin ParMicrosoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/C...r_vs_oracle.htm
http://www.microsoft.com/sql/evalua.../benchmarks.asp
tml" target="_blank">http://searchdatabase.techtarget.co...00.h
tml
vs-ss2k.pdf" target="_blank">http://www.oracle.com/technology/pr.../>
vs-ss2k.pdf
David G.|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin ParMicrosoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Par
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/C...r_vs_oracle.htm
http://www.microsoft.com/sql/evalua.../benchmarks.asp
tml" target="_blank">http://searchdatabase.techtarget.co...00.h
tml
vs-ss2k.pdf" target="_blank">http://www.oracle.com/technology/pr.../>
vs-ss2k.pdf
David G.|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Par
>
Labels:
benchmark,
benchmarks,
compare,
cons,
database,
databaseengines,
microsoft,
mysql,
oracle,
performance,
pros,
server,
sql
Performance benchmarks
Hello everyone,
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin ParéMicrosoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Paré
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci953120,00.html
http://www.oracle.com/technology/products/database/oracle10g/pdf/cwp_general_o10g-vs-ss2k.pdf
David G.|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
--
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Paré
>
I am trying to find some benchmark that compare different database
engines.
I already know what are the pros/cons of Oracle vs SQL, but I have to
come up with metrics to help us choose the best database for our needs.
Thank you!
Martin ParéMicrosoft wrote:
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I
> have to come up with metrics to help us choose the best database for
> our needs.
> Thank you!
> Martin Paré
Check these links:
http://www.tpc.org/
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
http://www.microsoft.com/sql/evaluation/compare/benchmarks.asp
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci953120,00.html
http://www.oracle.com/technology/products/database/oracle10g/pdf/cwp_general_o10g-vs-ss2k.pdf
David G.|||Just remember the old saying, "Statistics don't lie, but liars do
statistics." The only effective way to determine the best database for
*your* needs is to develop a test suite (based on your coding styles and
data usage patterns) and perform your own benchmarks.
If you really want a good laugh, then dig into the code behind some of the
benchmarks that have been published at tpc.org. I've reviewed code from
tpc.org published benchmarks that fooled the auditor, but would result in a
lack of transactional integrity in the real world. Beyond that, some of the
configurations that produce the highest throughput are unmanageable and
unsustainable in the real world.
I could delve into the implications of the OS, toolset, environment and
other factors that go into determining "which database is best," but I'm
tired of yapping on this subject.
--
Michael D. Long
Microsoft MVP - Windows SDK
"Microsoft" <martin.pare@.ortivusNA.com> wrote in message
news:eLYTDMuiEHA.2412@.TK2MSFTNGP15.phx.gbl...
> Hello everyone,
> I am trying to find some benchmark that compare different database
> engines.
> I already know what are the pros/cons of Oracle vs SQL, but I have to
> come up with metrics to help us choose the best database for our needs.
> Thank you!
> Martin Paré
>
Monday, March 12, 2012
performance : load xml file vs query xml field
Does anyone have any benchmarks or general knowledge regarding the performance System.XML 2.0 and SS05 for these two scenarios:
1. XPathDocument xpathdoc = New XPathDocument(pathToXMLFile);
2. storing the contents of the xml file in SS05 ( in a col of XML datatype ) , and using SQLHelper to load it into an xpathdoc
We haven't done such measurements. For case #2, you have a make a roundtrip to the server, which will be more costly than reading from the file, although I cannot say by how much.
I think a fairer comparison is to compare the processing for case #1 with running the query on the XML data type column at the server. XML indexes on the XML column can significantly speed up queries.
Thank you,
Shankar
Labels:
benchmarks,
database,
field,
file,
knowledge,
load,
microsoft,
mysql,
oracle,
performance,
query,
regarding,
scenarios1,
server,
sql,
ss05,
system,
xml,
xpathdocument
Subscribe to:
Posts (Atom)