943,580 Members | Top Members by Rank

Ad:
  • MySQL Discussion Thread
  • Marked Solved
  • Views: 3985
  • MySQL RSS
Jul 26th, 2008
0

MySql Vs Oracle

Expand Post »
I am stuck between deciding between MySql and Oracle,

The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not.

Any views on the same.?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
rich_m is offline Offline
18 posts
since Feb 2006
Jul 26th, 2008
0

Re: MySql Vs Oracle

Hello rich_m,

how are you?

I am afraid you will have to wait at the Greek calends.

Once MySql company had a wonderful oracle clone. It was MaxDB, formerly SAPDB. And lots of people thought they would drop ugly MySql database and replace it by MaxDB. But they returned it back to SAP in 2007.

krs,
tesu
Reputation Points: 158
Solved Threads: 98
Master Poster
tesuji is offline Offline
720 posts
since Apr 2008
Jul 27th, 2008
0

Re: MySql Vs Oracle

There should be some reason for this???? Any idea?
Reputation Points: 10
Solved Threads: 0
Newbie Poster
rich_m is offline Offline
18 posts
since Feb 2006
Jul 27th, 2008
1

Re: MySql Vs Oracle

You shouldn't compare the two. It's like comparing a school bus (Oracle) to a Corvette (MySql). Oracle can deliver tons of data in a reasonable amount of time consistently. MySql can deliver smaller amounts of data in a much faster time consistently. How big is the db and how frequent will it receive requests? Are you planning on having millions of users querying the db every 3 seconds? If so, Oracle should be your choice (or even better, IBM DB2). However, if you are predicting <10000 users and average query of 5 per minute or less, MySql will do all you have ever hoped for.
Reputation Points: 232
Solved Threads: 137
Practically a Master Poster
buddylee17 is offline Offline
665 posts
since Nov 2007
Jul 27th, 2008
0

Re: MySql Vs Oracle

@buddylee17 : Thanks for this info,
What I was interested was in knowing the features that I will be losing if I chose MySql
Reputation Points: 10
Solved Threads: 0
Newbie Poster
rich_m is offline Offline
18 posts
since Feb 2006
Jul 28th, 2008
0

Re: MySql Vs Oracle

Buddylee is right when he says that you shouldn't go for oracle if you intend to do a small project.

As a matter of fact there are benchmarks which shows that mysql offers almost the same performances as oracle when it comes to little data volumes (2 go or less) and few users (30 or less).

What's more, the price entailed by oracle doesn't lie only in the licence but also in the hardware (RAM, CPU) you need to achieve good performances.
gtd
Reputation Points: 18
Solved Threads: 4
Light Poster
gtd is offline Offline
31 posts
since Jul 2008
Jul 29th, 2008
0

Re: MySql Vs Oracle

Yes, Oracle is a beast and a memory hog. My favorite comparison was made by Charles Phillips, President of Oracle:
"We're both in the transportation business," Mr Phillips said. "We have a 747, and they have a Toyota."
Marten Mickos, CEO of MySql responded:
"There are many more Toyotas sold than 747s. "Toyota is a very profitable company"
Reputation Points: 232
Solved Threads: 137
Practically a Master Poster
buddylee17 is offline Offline
665 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: Run multiple commands at a time 4m notepad
Next Thread in MySQL Forum Timeline: Calculate Running total without ordered index





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC