Jump to content


Photo

ORACLE vs MYSQL


  • Please log in to reply
13 replies to this topic

#1 weknowtheworld

weknowtheworld

    Advanced Member

  • Members
  • PipPipPip
  • 85 posts

Posted 09 January 2007 - 09:24 AM

Hi,

Which would be more beneficial for me to use as a database oracle or mysql in all terms?

Thanks...  :)

#2 rjgoulet

rjgoulet

    Newbie

  • New Members
  • Pip
  • 6 posts

Posted 27 February 2007 - 02:18 PM

Depends on what you want to do & how much money you have for it.

#3 gluck

gluck

    Advanced Member

  • Members
  • PipPipPip
  • 216 posts

Posted 05 April 2007 - 05:03 PM

Mysql free but oracle charges.
I'm back baby!

#4 onepixel

onepixel

    Member

  • Members
  • PipPip
  • 18 posts

Posted 07 April 2007 - 12:53 PM

Mysql is definitly the way to go if you have a small busness. It's free, found in almost all web servers and easy to use.
<a href="http://www.saheltech.com">PHP Programming - WordPress Blog Customization</a>

#5 gluck

gluck

    Advanced Member

  • Members
  • PipPipPip
  • 216 posts

Posted 10 April 2007 - 01:22 PM

My vote to mysql.
I'm back baby!

#6 emocat

emocat

    Newbie

  • New Members
  • Pip
  • 3 posts

Posted 24 May 2007 - 01:26 PM

Oracle Database XE is also free:

http://www.oracle.co...e/xe/index.html

#7 tommyboy123x

tommyboy123x

    Advanced Member

  • Members
  • PipPipPip
  • 106 posts
  • LocationScottsdale, AZ

Posted 31 May 2007 - 12:05 AM

i know people who use oracle that get mad when i say i still use mysql but i think its just fine

"One of the best GPT sites ever!"
Offers: Over $2000 | Referral Commission: 15-25% | Payout Time: 3-5 Business Days


#8 $username

$username

    Advanced Member

  • Members
  • PipPipPip
  • 159 posts

Posted 21 June 2007 - 01:27 PM

I work with database at work all day. To me as long as long as the database does its job and does not crash. I think its an ok database.
Not to be a name dropper but the ones I have worked with are....

Oracle =  For the price it is worth the support and the database.
SAPDB = SAP's Database and now its MAX DB
MYSQL = This is great piratical database.

To me they are all do the same work. If I had to choose what one to work with it would be MYSQL. It is a free product, and everyone has worked with it, and made many modifications as well as documentation on how to do anything. I feel that this is the best thing when developing an app that works with a database. It allows for better support.

Brett

If you think it was easy, you did not learn anything. Try something harder.

#9 Foser

Foser

    Advanced Member

  • Members
  • PipPipPip
  • 272 posts

Posted 10 July 2007 - 09:33 PM

would oracle be faster or more powerfull if i have a databse driven website and i would receive an extreme amount of people to the website?

#10 Azu

Azu

    Advanced Member

  • Members
  • PipPipPip
  • 1,047 posts
  • LocationU.S.A.

Posted 12 July 2007 - 08:58 AM

It should be, considering all the hype it has to live up to.

#11 Nakor

Nakor

    Member

  • Members
  • PipPip
  • 13 posts

Posted 30 July 2007 - 01:15 AM

PHP's integration with Oracle would be no more efficient than it's integration with MySQL. Unless you are running an enterprise system there would be little to no difference between the two.

#12 gizmola

gizmola

    Advanced Member

  • Administrators
  • 4,116 posts
  • LocationLos Angeles, CA USA

Posted 20 November 2007 - 03:27 AM

You're not going to get a worthwhile answer without more information about what you're trying to do. 

With that said, here's a few observations I have for you.  Oracle is a database that runs on just about every computing platform anyone is using, while mysql is predominately a unix program (although there is a windows and mac version).  Oracle has scalability features and a mature set of features that go substantially beyond what MySQL offers.  One of Oracle's great strengths is it's concurrency system, that by default offers versioning, known in Oracle terms as "read consistent views."  Basically, with Oracle, there is no need to have readers and writers contend with each other. For example, let's say that you are doing a query of a table of transactions in order to create a financial report.  The query needs to go through the entire table row, adding credits and subtracting debits.  In most databases, the solution to this problem is to put a "read" lock on the table, which would prevent updates from occurring to any of the rows of the table for the duration of the query.  If this was a large table, this locking period could really slow things down and be very undesirable for a high transaction system.  Suffice it to say, that Oracle doesn't require read locks of any kind, and that query runs fine and will not interrupt inserts, updates and deletes.  Oracle also offers highly functional stored procedures and triggers, including the ability to write sprocs in either pl/sql language or Java.  MySQL zealots love to debate this stuff, but point of fact there's a huge list of features Oracle has that MySQL doesn't, and probably won't anytime soon.  The thing that people typically point to is that MySQL's default mode (using the myisam engine) doesn't have support for transactions, or declarative referential integrity, both of which are meat and potatoes RDBMS features you find in about any other rdbms database (including Postgresql btw). 

MySQL is a bit of an oddity in the relational database world.  It offers a unique feature that depending on how you look at it, is either a strength or a weakness: that of storage engines.  As I mentioned, MySQL's myisam engine doesn't support transactions, while the Innodb engine does.  This allows mysql to do some very cool things with specialized engines.

Where PHP is concerned, MySQL has a property that works very well, in that PHP has page scope.  This means that PHP offers no persistence mechanism ... when a script runs it creates variables, and when that script is done, all the variables are garbage collected.  Because MySQL connections are very lightweight, there's almost no overhead in creating a MySQL connection, which works well with PHP's design.

Oracle on the other hand, has a heavy connection process that can on the order of seconds.  Oracle has a session concept, and connections in general should be pooled and reused.  With Oracle, you make one connection if you need to do multiple queries, and issue the seperate queries using oracle sessions. Often people who don't understand this don't realize that they needed to use the ora_pconnect rather than the ora_connect.  There was almost no info on this in the old oracle client manual pages.

Another key difference that helps with PHP is that MySQL's query execution process is far more lightweight in general use than Oracle's.  Oracle makes extensive use of query execution caching, however, the use of dynamically generated SQL statements as is common in PHP applications will result in very poor performance, because these statements will not be cached by Oracle.  Oracle requires the use of bind variables in order for Oracle to pull statements from it's query cache.  Many people find the work that you need to use bind variables to be tedious, although the increased interest in PHP security, and the development of PHP PDO are both developments that may have helped people appreciate the security benefits that can be had.

Plainly speaking, PHP just didn't work very well with Oracle in the past, and was a bitch to get setup, requiring a pretty extensive understanding of Oracle, and the various client environment variables and client libraries.  In comparison, getting PHP setup with MySQL was simple and easy. 

In the past couple of years, Zend entered into some agreements with Oracle post PHP 5, and work on integration with the Oracle library was stepped up significantly.  Part of that was a rewrite of the oracle client library to support 8,9 & 10 features, and BLOB types.  This client offers additional functions, as well as a variety of variables that allow you to tune connection caching, along with articles you can find on the Oracle Technology network, using PHP with Oracle is a lot more viable than it used to be.

#13 ghe

ghe

    Member

  • Members
  • PipPip
  • 27 posts
  • LocationPilipinas

Posted 25 November 2007 - 10:29 PM

Good day,

For me, I really go for "Oracle". Its the best option you can have when it comes to database, though there is this "Cache" which, some says, had already surpass "Oracle", but "Oracle" has already been established well in the industry compared to this "Cache". Ahm, but the sad part of this is, "Oracle" (as what others already have said in this topic) is not FREE.

Regards,

#14 rameshfaj

rameshfaj

    Advanced Member

  • Members
  • PipPipPip
  • 287 posts

Posted 31 December 2007 - 06:25 AM

I think Oracle is useful for large domain problems and Mysql is also fine if we get good tools for it.
Ramesh




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com