All things being unequal,
Could somebody help me out please on choosing between
Informix, MySQL, Oracle & SQL Server (not for home use).
Judging from the benchmarks on the mysql website Oracle
is pretty much dead on arrival as far as choosing it
over the others is concerned. MySQL appears to kick
Informix's butt as well.
That said they has stored procedures (which mysql does not
yet seem to have) so they might actually have a bit more
of a fighting chance - does anybody know how they compare
against mysql when stored procedures are used?
[it's cheating slightly, but I'm more interested in
getting the last drop of performance out of the better
choice of DBMS rather than being fair to be brutally honest].
To put a bit of perspective on this, the dbms will have
Windows clients (using odbc) [though a web interface might be
implemented some time in the future] - and there isn't a superbly
specced machine available to house the DBMS; a 133Mhz pentium
with 32 mb ram and a 1.2 gb harddrive.
Because of the spec of the machine SQL Server is really not
an option (thank Ghod) so I'm thinking along the lines of
redhat+oracle/mysql. But I'm still torn between believing
the benchmarks on the mysql website and going for Oracle
regardless for it's stored procedures & triggers.
any opinions on this would be greatly appreciated.
thanks
Ken
****************************************************
Ken Guest
Credo Group Limited
Tel: +353-1-6310200
Fax: +353-1-6310300
Internet Address: kengu at credo.ie
Home Page: http://www.credo.ie
"THE VIEWS AND OPINIONS EXPRESSED IN THIS E-MAIL
MESSAGE ARE THE SENDER'S OWN AND DO NOT NECESSARILY
REPRESENT THE VIEWS AND THE OPINIONS OF CREDO GROUP
LIMITED OR ITS PARENT COMPANY"
****************************************************
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!