MySQL Forums
Forum List  »  Oracle

Re: sql compatibility
Posted by: kalaid vani
Date: August 08, 2007 01:04AM

Hi
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.

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. Oracle are only limited to large corporations due to licencing costs and not all hosting companies have Oracle (they might have SQL Server, but not Oracle).

You can make billions of data with MySQL, but it will be slow on the server. In addition, backing up the MySQL database takes forever, versus Oracle's tools which makes database backup a cinch.

If you are going to use MySQL, then add lots of memory. In addition, I recommend that you seperate the Website from the database. In other words, have emails and website on a seperate server and only have a dedicated MySQL server specific to mysql/db only.

MySQL is Free, It's everwhere, that's the whole concept!!!

I prefer Oracle than Mysql

http://www.codingcoding.com||
http://www.mycollege.in

Options: ReplyQuote


Subject
Views
Written By
Posted
3511
August 07, 2007 11:47AM
Re: sql compatibility
2685
August 08, 2007 01:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.