Page 1 of 2 12 LastLast
Results 1 to 15 of 23

Thread: Oracle vs MySQL

  1. #1
    Join Date
    Apr 2008
    Posts
    1

    Unanswered: Oracle vs MySQL

    Hi, i have been working at <snip> for 6 months. they create oracle based systems and web development using mysql as a primary back end DB system. few days back i with a developer had a bet weather mysql is better in query processing or mysql. I dont kno from where he got info he said mysql is better because nasa also uses mysql for its db needs. i don't know if its right or wrong but i do want to know which one is better when using for web apps having substantial query processing involved. my opinion is oracle (with JSP) and my friend says mysq with php need help. we had some very limited bench marks but its difficult to guess. Need help of some bd master in this regard. Thanx
    Last edited by r937; 04-22-08 at 19:01.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Which is better Ford or Chevy?
    Which is better Coke or Pepsi?

    Why not add MS SQLServer & Postgress to the religious discusssions?

    The answer is neither or both.
    It depends.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I wouldn't quite agree.

    Which is better Ford or Chevy? - I don't care.
    Which is better Coke or Pepsi? - Coke, of course!



    As of NASA, World Socialist Web Site says that
    Until the Columbia disaster, NASA still had some computers running with Intel 8086 microprocessors ...

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which is better, oracle or mysql?

    it depends on two things: (1) how much money can you spend on it, and (2) who is going to administer it

    answer those questions and i will tell you which one is better
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Apr 2008
    Posts
    28
    Quote Originally Posted by usman911
    but i do want to know which one is better when using for web apps having substantial query processing involved. my opinion is oracle (with JSP) and my friend says mysq with php need help. Thanx
    Well, in my opinion MySQL is faster because it's lighter (and if you get rid of transactions is even faster!), but that doesn't means better, because the implementation of MySQL is younger than Oracle's. We got SP on r5 , Oracle has objects since 8i... ten years ago!

    I must add another criteria: what the purpose will fulfill?

  6. #6
    Join Date
    Aug 2003
    Location
    Chittagong,Bangladesh
    Posts
    1

    its correct..

    Quote Originally Posted by r937
    which is better, oracle or mysql?

    it depends on two things: (1) how much money can you spend on it, and (2) who is going to administer it

    answer those questions and i will tell you which one is better
    its correct..

  7. #7
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by OracleDisected
    and if you get rid of transactions is even faster!
    Why use a RDBMS when you don't care about transactions?

    And besides: MySQL it get's a lot slower when used with heavy concurrent reads and writes (especially when not using InnoDB)

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Quote Originally Posted by Littlefoot
    I wouldn't quite agree.

    Which is better Ford or Chevy? - I don't care.
    Which is better Coke or Pepsi? - Coke, of course!



    As of NASA, World Socialist Web Site says that
    I agree with everything you say except.....Pepsi rules
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  9. #9
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I agree with everything you say except.....Pepsi rules
    You obviously haven't tried Coca Cola 10.2.0.4
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  10. #10
    Join Date
    Apr 2008
    Posts
    1
    it depends on two things: (1) how much money can you spend on it, and (2) who is going to administer it

    I SUPPORT THIS QUOTE VERY MUCH

  11. #11
    Join Date
    Apr 2008
    Posts
    28
    Well, MySQL claims that Google uses their DB a lot... even at the backend of their powerful search engine, mm I think that money isn't the driver there... talent? they have a lot...

    What happens now that SUN owns MySQL?

    I rather go with Coke, except for Pepsi Max.... you know that Pepsi is selling a 'retro' version here in Mexico that tastes like molasses?

  12. #12
    Join Date
    Mar 2008
    Location
    Seattle
    Posts
    11
    I don't know a damned thing about MySQL, and I don't drink soda... so chances are, if I was your DBA, you'd be using Oracle.

  13. #13
    Join Date
    Apr 2008
    Posts
    28
    That bad is weather at Seattle?

    Cheer up dude! ... I already use Oracle, teach at University level both MySQL and Oracle, use MySQL with Drupal/Wordpress/phpBB. I know both worlds...

    ...and fortunately: you're not my DBA.
    (nothing personal, just business)
    Last edited by OracleDisected; 05-01-08 at 13:24.

  14. #14
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Quote Originally Posted by OracleDisected
    Well, in my opinion MySQL is faster ... (and if you get rid of transactions is even faster!), ...
    Wow, no transactions? then what, just look at the nice file names and guess whats in them? YES the speed of thought is faster that light travels!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  15. #15
    Join Date
    Apr 2008
    Posts
    28
    I'm just telling what is possible, because MySQL provides a transaction less engine; I'm not saying it's the best thing you can do when talking about data integrity and availability, those are distinct things that are defined by the business needs.

    What if the business needs speed, the solution do not require transactions (return to a previous state of data), and don't have the money for more expensive RDBMS?
    It's a rare combination, but exists...

    "Transactions" in my remark quoted by you, refeer not the nature of the data, but the inner workings of the DB related to COMMIT/ROLLBACK, redo logs, etc.
    Last edited by OracleDisected; 05-01-08 at 14:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •