Mysql vs Oracle

[Frenzy]

Hi,

I was wondering why people says that Oracle is better then Mysql for large sites. Can anyone tell me the price for Oracle please. I also know that developpers charge alot more for Oracle.

Waiting for replies,
Max

[Koolguy]

Oracle varies from $200 to $750 bucks a year while MySQL is free and open source.

[ashben]

MySQL Rocks!

Read this : http://www.mysql.com/news/article-51.html

[Woofcat]

I've heard more about large sites ditching Oracle for MySQL than the other way around...

[atlas]

Oracle is a far more robust and feature-filled database than mySQL. MySQL is great for small or mid-size sites, but when you start needing things like transactions, triggers, or have more entries than a few million -- you need oracle.

mjk@atlascgi.com

[jvv]

mySQL chokes when it gets hunderds of simultanious connections, orcale doesn't :). But unless you have a database intensive site that pulls several ten thousands a day, stick with mySQL.

[Semiel]

>transactions, triggers, or have more entries than a few >million -- you need oracle

I think the new MySql version supports transactions (commit, rollback). If i remember correctly, stored procedures are not supported though. A "few million entries" is not that much data to handle and will work great with MySql.

[Koolguy]

Yeah, you are more likely to use up your hard disk space then run out of supported room in mysql. If you set it up right btw.

[Vinay]

I'm starting to prefer PostgreSQL ( http://www.postgresql.org ) now .. simply because its free, and it has TONS of more features that Oracle has, AND its catching up in speed to mySQL .. which is a good thing