> I am by no means an Oracle (or any other database) zealot. They all have
> their strengths and weakness, and given a choice, I'll choose the one best
> suited for the particular job I am doing. If I could only choose one
> database for everything, it would probably be DB2.
>
> I will respectfully submit that you have never worked on a truly well-tuned
> Oracle implementation.
>
> In my experience, 90% of Oracle application implementations are seriously
> broken. Poor performance is not the fault of Oracle if the developers and
> DBAs are inadequately skilled at using it. For a short while I worked as
> an Oracle7 performance consultant (good money, but really boring).
[cut text]
> Truly expert Oracle developers are far and few between indeed.
I likely will not use one database for everything. Based on the
information I have received in this thread, I will likely use MySQL for
the individual stores (because of its light footprint), MySQL for the
web site, and something else, likely Oracle for the central repository
that feeds the MySQL web site and the stores.
James: Since you have been a consultant for Oracle and are fimiliar with
DB2, which of the two would you recommend as the central repository?
For this, I would like a more flexible security model, decent
performance, triggers (peferably that can reach external programs),
DBI/DBD interface, scalability (ability to run accross clusters is a
definate bonus). Ability to run on Linux, FreeBSD and (ack!) WinNT is a
bonus as well. I think that if I used MySQL for this repository, I may
have to write a whole suite of Perl scripts to secure the database and
monitor changes.
--
______________________________________________________________
thomas delbert wilkinson thomas@stripped edmonton canada
I picked up a Magic 8-Ball the other day and it said 'Outlook
not so good.' I said, 'Sure, but Microsoft still ships it.'
