SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Wizard johnn's Avatar
    Join Date
    Mar 2001
    Location
    Southern California, USA
    Posts
    1,181
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Testing 5 major databases at Eweek

    Article:
    http://www.eweek.com/article/0,3658,...a=23115,00.asp

    Charts:
    http://www.eweek.com/slideshow/0,301...a=23120,00.asp

    Out of 5 major databases (latest versions) DB2,SQL Server, MySQL, Oracle 9i, Sybase ASE, it says Oracle9i and MySQL loggged the highest throughput and fastest response times.

    John

  2. #2
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    That's nice. Next time I need Oracle9i I think I'll just use MySQL instead
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  3. #3
    \m/ R.I.P. Dimebag! \m/ JimBolla's Avatar
    Join Date
    Dec 2001
    Location
    erie, pa
    Posts
    1,130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    From reading that article, I am under the impression it moreso tested "what database has the best drivers for our platform" as opposed to "who has the best database engine." I think the only way they could really test engine strength is if they built solutions in a variety of development platforms, JAVA, ASP, PHP, etc and then compare results for each of these. But of course this would take a lot of work and so it probably won't happen.

  4. #4
    Database Jedi MattR's Avatar
    Join Date
    Jan 2001
    Location
    buried in the database shell (Washington, DC)
    Posts
    1,107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by crowdozer
    From reading that article, I am under the impression it moreso tested "what database has the best drivers for our platform" as opposed to "who has the best database engine."
    That's the impression that I received as well.

    Plus, it looked strictly at performance -- not 'ease of use', development time, etc.; e.g. Total Cost of Ownership. Oracle 8i has like a 1GB footprint (e.g. takes up a GB on your hard disk), and I think 9i is around 1.5GB. MySQL is tiny, Sybase ASE is around 200MB, etc.. Oracle is a BEAR to administrate/configure, MySQL / MS SQL are really easy to configure. MySQL has poor replication, and may suffer more downtime per year than Sybase ASE which has the best replication of them all, but costs a lot of money. etc.

    As I always say: Use the best tool for the job!. People who take benchmarks seriously are either Zealots who say "We're #1! YEAH! Everyone should use our product now!" or managers who think that this is the only yardstick you need to decide on a RDBMS platform.

    I'd say this is a clear LOSS for Oracle, seeing as it is roughtly 10 to 15x more expensive than Sybase but only 1.5x faster. And it is infinitely more expensive than MySQL which is free!

    Plus they only stopped at 1000 users. 1000 users really isn't that much nowadays. I'd rather see 5,000 and 10,000 users -- see where the RDBMS's start choking and dying off. I want to know what is the MAX not when it plateaus.

    Also with MySQL they state the Record Cache is what they used to get those stellar numbers. Without it was roughly 2/3rds less (sux0r!). To really test MySQL you need to mix a lot of inserts/updates as well, you know, the things that really kill it but are pretty much often-used in most OLTP systems (yeah if you're a magazine site you can live with static content but you'd be better off pushing it to HTML in the first place!). I want to know what the overhead is in maintaining the record cache (updates, inserts, deletes will invailidate the record cache and it will need to be regenerated). What if 10% writes totally kill the system due to the record cache overhead? It could negate the performance benefits.

    To MS SQL Server's credit, they concede that the JDBC drivers weren't the best. Then why did they use them in the first place! If I understand it correctly, JDBC is like ODBC in that it offers 'one-size-fits-all' connectivity, right? It's well known that ODBC is far slower than the native DB libs -- so you'd never use it in a production environment without some sort of logic dictating that you HAD to. Same thing here. Why not use the OCI layer for Oracle, or the Sybase-CT libs for Sybase. Or the .NET libs for MS SQL. That is what you would use if you really wanted to squeeze performance out of your system.
    Last edited by MattR; Mar 4, 2002 at 12:49.

  5. #5
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    This was incredibly limited testing and is pretty nearly useless...

    Kind of like the TCH testing
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •