MYSQL and Oracle

Anon

Hi,

May i know where can i find some topic about the differences and some comparison between MYSQL and Oracle? Does anyone have the same experience using both database?

Any related information is very appreaciated.

Thanks
Louis

Anon

Hello Louis,
I am running both databaseses on one system and it is working fine. Oracle is much more comfortable than MySQL. Oracle allows p.e. Trigger, Procedures and Funktions witch MySQL doesn't. The connectivity between Oracle and PHP could be better, at this point MySQL is a bit better.
So far,

Regards,

Sascha

[deleted]

You can't really compare Oracle with MySQL.
Oracle is a professional, high-grade relational database, and MySQL is a very limited, simple flatfile interface.

Oracle wins with one CPU tied behind it's back.

It would be better to compare Oracle to PostgreSQL, because they are much closer in functionality and performance.

Anon

Well, when you want to keep It simple and quick, which applies for most Internet Projects, Mysql ist a good choice.

e.g. look at www.wallstreetonline.de
They run moree than a million impressions per day and they've got plenty of traffic.

Everything is mysql and php.

[deleted]

True, MySQL is a simple and fast database, but the complete lack of any kind of functionality means that you often have to do a lot of scripting to do what real databases can do by themselves. Things like foreign keys, functional indexes, stored procedures, triggers.

Basically, if you want to do just a little more than "SELECT * FROM table" in MySQL, you have to do it in a script, where real databases like PostgreSQL and Oracle let you do it in the database, making it a lot faster and much more reliable.

Anon

I totally agree with you, I've worked with both of them and saw advs and disadvs...

As I've got my introduction to foreign keys from you Vince, maybe I have to 🙂)

[deleted]

hehe... you never have to agree with me, but you will suffer the consequences if you don't! :-)