Nishka's answer looks good, especially since he found the website that
I found before I ask the question. To test something/someone you
always should have an answer to compare with, right? So this first
question of mine on Google Answer was prompted by a question a friend
asked me over the phone. On which I then spent about 30 or 40 mins
researching (perhaps that was worth only USD4 ;). Anyway, here was my
answer to that friend for comparison.
----- Original Message -----
From: S.M.Sabri S.M.Ismail
To: Mohamad Jamil Sulaiman
Sent: Friday, April 26, 2002 11:13 AM
Subject: Databases comparisons for your reference ...
Dr Jamil,
}} As per our phone discussion, some databases comparison for your
reference ...
http://www.eweek.com/print_article/0,3668,a=23115,00.asp (extracts
below)
February 25, 2002
Server Databases Clash
By Timothy Dyck
Finding solid performance data to help choose among competing
technologies is as tough as creating the data in the first place. This
is particularly true in the database space, where database vendors
routinely use no-benchmarking clauses in their license agreements to
block publication of benchmarks of which they do not approve.
Still, this is data that customers should have to make informed
purchases, and, as we've found again and again at eWEEK Labs,
benchmarking is an unmatched technique for flushing out unexpected
technical strengths and failings that can make or break a project.
[...]
We tested IBM's DB2 7.2 with FixPack 5, Microsoft Corp.'s SQL Server
2000 Enterprise Edition with Service Pack 2, MySQL AB's MySQL 4.0.1
Max, Oracle Corp.'s Oracle9i Enterprise Edition 9.0.1.1.1 and Sybase
Inc.'s ASE (Adaptive Server Enterprise) 12.5.0.1.
Overall, Oracle9i and MySQL had the best performance and scalability
(see charts, images 1 and 2 in slideshow), with Oracle9i just very
slightly ahead of MySQL for most of the run. ASE, DB2, Oracle9i and
MySQL finished in a dead heat up to about 550 Web users. At this
point, ASE's performance leveled off at 500 pages per second, about
100 pages per second less than Oracle9i's and MySQL's leveling-off
point of about 600 pages per second. DB2's performance dropped
substantially, leveling off at 200 pages per second under high loads.
[...]
Direct comparability was a major goal of the benchmark. All databases
were tested on the same hardware platform (Hewlett-Packard Co.
provided HP NetServer LT 6000r servers with four 700MHz Xeon CPUs, 2GB
of RAM and 24 10,000-rpm 9.1GB Ultra3 SCSI hard drives used for
database storage) and the same operating system (Windows 2000 Advanced
Server with Service Pack 2).
We used a Web-based bookstore application called Nile to generate
database load and stress-tested Nile using Empirix Inc.'s e-Test Suite
6.0 load testing tool, with loads from 50 to 1,000 concurrent Web
users.
We selected BEA Systems Inc.'s WebLogic 6.1 with Service Pack 1 as our
application server platform (see related story) and wrote the Nile
application in JavaServer Pages. [...]
}} And DB2 versus Informix future directions ...
http://www-4.ibm.com/software/data/informix/directions.html (extracts
below)
Informix Portfolio: Future Directions
"There will be no forced migration to DB2," said Janet Perna during
her keynote speech at Giga Information Group Inc.'s GigaWorld IT Forum
in Las Vegas. An IBM white paper discussing IBM's future direction for
Informix products confirms IBM's intention to protect Informix's
customers investments, not forcing anyone to migrate to DB2 and
reiterates support for multi-hardware platforms and open standards.
The white paper IBM Informix Portfolio Future Directions has been
substantially updated. This document sends a tremendously impressive
message to all of our customers and partners, since it conveys a
message of secure investment to the IBM Informix users and a thrilling
picture of innovation and advancement to the industry at large.
To obtain a copy of revised paper, please contact your account
representative. The "IBM Informix Portfolio Future Directions" Version
2 white paper is directly available to registered commercial members
of IBM PartnerWorld for Developers and registered IBM Informix
Solutions Alliance Partners.
... implying IBM prefers migration from Informix to DB2, but will
allow/support (to some extent) IBM Informix users who don't want to.
}} The above found using appropriate google keyword
}} searches "database+unix+comparison+benchmark",
"db2+informix+future".
Hope that helps.
regards,
S.M.Sabri S.M.Ismail |