Glenn Nicholas wrote:
Thanks for the responses, much appreciated.
A reference was made to Oracle/DB2/WebSphere being resource intensive
"Then, the big stuff started to become available. DB2, Oracle,
Websphere. One copy can take multiple IFL engines .."
My follow up question on this is: in terms of resource requirements,
would you treat MySQL as being roughly equivalent to Oracle/DB2?
I'd not compare MySQL with Oracle or DB2: last I looked at MySQL there
were several relational features omitted because they "are too expensive."
There is a performance-measurement, tuning and fixing site whose name I
forget but which may be associated with OSDL. It's a partnership
involving IBM and some other heavyweights (and probably some
lightweights too).
Participants throw workloads at a heap of iron (big Power boxes
feature), analyse what doesn't work so well and how to fix it. It's the
place you'd go to work on memory management, paging, I/O issues and such.
One of the loads described in an IBM paper involved Postgresql, and it
goes to some length describing why one shouldn't expect stellar
performance from Postgresql in comparison with, say, DB2.
It provides a good background on the significant technical differences
between Postgresql and commercial software such as DB2 and Oracle.
If you're happy to substitute some other OS DBMS for MySQL, then a
comparison with Firebird (formerly Interbase), Ingres and whatever
Adabas has become would be interesting.
--
Cheers
John
-- spambait
[EMAIL PROTECTED] [EMAIL PROTECTED]
Tourist pics http://portgeographe.environmentaldisasters.cds.merseine.nu/
----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390