General discussion

Locked

DBMS Selection

By jonathan_wallman ·
I have to recommend a DBMS to support a series of applications that will have enormous volumes, both in terms of on line transactions and batch processing. Can you point me to any benchmarks that will help with my decision?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

DBMS Selection

by Bob Sellman In reply to DBMS Selection

There was an extensive comparison published in the February 25, 2002 issue of eWeek. It compared Oracle 9i, MySQL, SQL Server, DB2, and ASE.

The analysis was based on performance without considering the costs. The interesting thing was that thetop performers for databases with many users were the two databases at opposite ends of the spectrum in cost: Oracle and MySQL. MySQL is free and Oracle is extremely expensive.

Because this article also discusses tuning of each database and related considerations, a careful reading should provide you with the performance analysis information that, when combined with other factors that you can investigate separately (price being a primary one for most people), you will be able to make some informed recommendations.

Since you mention that your applications will have enormous volumes of both transactions and batch processing, this independent published study should be exactly what you need.

Collapse -

DBMS Selection

by jonathan_wallman In reply to DBMS Selection

Poster rated this answer

Collapse -

DBMS Selection

by jonathan_wallman In reply to DBMS Selection

This question was closed by the author

Back to IT Employment Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums