Re: Performance benchmarks

From: Michael D. Long (michael.d.long-nospam_at_comcast.net)
Date: 08/27/04 

Date: Thu, 26 Aug 2004 21:19:47 -0400

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é
>
>

Relevant Pages

  • Re: [PHP] Re: how to display images stored in DB
    ... It has almost nothing to do with benchmarks. ... The web browser sees an image as a single HTTP request. ... script engine, parsing the script, and executing a SQL query to retrieve ... the image from the database is less efficient than letting the web server ...
    (php.general)
  • Re: [PHP] Re: how to display images stored in DB
    ... It has almost nothing to do with benchmarks. ... the image from the database is less efficient than letting the web server ... I'd keep it in a database, then when I need it cache a local copy on the ... scalable system for accessing system services | ...
    (php.general)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.server)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance benchmarks
    ... Just remember the old saying, "Statistics don't lie, but liars do ... data usage patterns) and perform your own benchmarks. ... other factors that go into determining "which database is best," but I'm ... Microsoft MVP - Windows SDK ...
    (microsoft.public.sqlserver.fulltext)
Loading