Re: Oracle or mySQL

Mark wrote:

> Please advise the advantages of using Oracle over mySQL.
>
> I currently use Access database work with Cold Fusion. Now I need a
> more powerful database that can handle more users and with high
> security and transaction consistency.
> I now need alot of reasons why I should pay for Oracle instead of
> using the mySQL database.
>
> Also Oracle has PL/SQL and what language does mySQL have similiar to
> PL/SQL language for interacting with database such as writing triggers
> etc..
> Is PL/SQL another reason why Oracle is better than mySQL?

One would have to know a lot more about what you are doing to make a recommendation. How many users? What transaction volume? What types of data? What types of transactions? What security requirements? What need to be operating system independent? What internal skill sets.

One of the largest internet retailers in the world has consistently evaluated dumping Oracle and moving to an open-source product. Every time they finish their evaluation ... they write Oracle another check. So the differences, if you need them, are extremely significant.

Be sure, too, you look at availability requirements and the ability to recover from a loss of hardware, loss of storage media, and other similar disaster scenarious.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)