PDA

View Full Version : Oracle vs MySQL


kona72
08-02-2006, 04:06 PM
Anybody have any experience with Oracle DB? just curious.... I have someone who uses Oracle and they love it. Trying to convert them....

domedia
08-02-2006, 04:22 PM
*cough* as you know I don't know much server side stuff... But I do know plenty of people that is running PHP/MySQL that wish they could afford to use Oracle.

kona72
08-02-2006, 04:35 PM
any ideas what the main advantages of Oracle would be?
:D

domedia
08-02-2006, 05:36 PM
From what I've heard it handles large scale better, but what do I know :)
I think it's unfair to compare mysql to oracle, one of the links below mentions it as "comparision of dolphins with nuclear-powered submarines" :-)

I googled a little and came up with these:
http://www.suite101.com/article.cfm/oracle/115560
http://www.devx.com/dbzone/Article/20743
http://forums.mysql.com/read.php?61,18127,18127#msg-18127
http://sql-info.de/mysql/vs/mysql-oracle.html

Creative Insanity
08-02-2006, 10:55 PM
I agree. Oracle and mysql are chalk and cheese.
Oracle is expensive but it does handle way larger files.. like in the terabyte range.
So if you think your database will get that big then hand in pocket.
If not then stick with mysql.
Don't do a 'Jones' trick and get it because someone else is using it and trying to get you to.
I am a firm believer in that if something is doing the trick then why change, but if you feel a change is needed for future proofing then go for it.

The only places I see using a database that size would be goverment departments and maybe the health sector. Also maybe a HUGE corperation like MS. Other than that I cannot see much need to change.