Can somebody tell me if Oracle is better than MySQL ??
I used to work on MySQL for the past months .
but when the time I've host my own online game server in my house,
it seems that MySQL can't monitor many accounts at a time .
And also my friend told me that he's using Oracle because it has more
dedicated commands than that of MySQL ..
so can somebody tell me the advantages and disadvantages between
Oracle and MySQL ??
if you google for it and spam here the results, i'm sure it will be counted as good quality posts.
here is a similar comparison: is a spaceshuttle better then a cessna 182? i'm pretty sure you can go to places in a spaceshuttle, but the cost...
For a big project where you are investing large amount of money and a powerful database is needed, the oracle is the option. In case of web content management and in some web application you can use mysql, it is free and can most of the work related to database that oracle can do.
These days, there's really very little difference. Oracle is more geared towards and thus may perform better with very large deployments, it is true, but the thing that actually makes a difference is having optimized queries and sensible indices.
Oracle is premium soft, it is best for any system setup relational database, many supporting tool , but no free.
MySql is FREE, but slower than Oracle.
I have ever worked for mobile game company, they use Mysql for database.
I enjoy working with both engines.
MySQL - is relatively light-weight, can be extremely fast when applications leverage architecture. Lots of features stay free as the database servers grow such as replication and partitioning.
Oracle offers lots of feature/functionality for solving complex problems. Supports large OLTP environments as well as VLDBs and can be very expensive.
I think it depends on how it is used. oracle is best for large scale databases
Also Mysql is also owned by oracle so perhaps some of its features are almost similar