What r the Advantages of Mysql over Oracle?

[iimmdeepak]

Hello
all i m using oracle as the data bast i want to know what r the advantages of MySql over oracle
Thanks

[jimmyD]

I'm not 100% sure, but I think Oracle could cope with tables that had much more records in or a bigger table size.

MySQL may have catched up now, but not sure.

[cpace32]

The differences are pretty minimal now, to be honest. What size DB will you be using? How many requests/second are you thinking you will get?

[Jiberish]

I would say none. Oracle is more complete, although not as simple to use for the beginner perhaps.

[jurwanwall]

Oracle is much versatile than MySQL. Oracle can run and handle more transactions than MysQL. Oracle would be better if you are going to have lots of db usage. I've used MySQL. Only for a forum. Still, MySQL takes up resources with PHP that affected the server load. Oracle on the other hand is better with memory leaks and handles multiple threads. You can do SQL Transactions, stored procedures, DTS in Oracle that you can not do in MySQL earlier versions. Oracle is expensive, although they came out with Oracle Free Edition to attract MySQL users. MySQL users enjoy this database because it is available on virtually all hosting companies

[israpost]

oracle supports a large no. of databases while MYSQL not...

[tylerlongtw]

mySQL is much light weight as compared to Oracle, Oracle is an enterprise level database which consumes lots of resources and is implemented only in big environment where as mySQL is more focused