SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2012
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL vs Oracle - Scalability

    Hi,

    My client is looking to build an ecommerce site but wants Oracle as the backend (to handle the entire business from end to end, not just the webapp part) because he's been told that MySQL (and MS Access) will choke when the numbers start rising. I'm not a database expert, can someone tell me whether this statement is valid? Below are the client's points:

    'Iíve had two unrelated IT experts that I trust generally, both tell me that I need Oracle after Iíve described in detail the complexity and scalability I need. Within a few years we expect to be processing 100,000 orders per year, buying and analyzing hundreds of thousands of dollars in Google Adwords, etc. Iíve been told that MS Access or MySQL will choke when we scale up.'

    Thanks in advance,
    Xavier.

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    statement is crap

    mysql scales up just fine (ms access, though, doesn't)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast
    Join Date
    Sep 2012
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    statement is crap

    mysql scales up just fine (ms access, though, doesn't)
    Haha, that's a pretty definitive statement r937! Would that still hold good for the client's entire gamut of requirements below?

    'the complete end-to-end web and IT system? An integrated database that does everything in our company (capture and facilitate all orders, customers, inventory, fulfillment, tracking, customer service, capture Google Adwords analytics downloads, data mining to pair up click-thrus with orders and improve our Adwords buysÖ)'

    We are conducting a feasibility study on a webapp product that seems to be promising (it's called Oorjit, seems shop.com is one of the users) and need to validate these database queries before finalising. Would you by any chance also know any product similar to Oorjit?

  4. #4
    Barefoot on the Moon! silver trophy Force Flow's Avatar
    Join Date
    Jul 2003
    Location
    Northeastern USA
    Posts
    4,606
    Mentioned
    56 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by maxdp73 View Post
    My client is looking to build an ecommerce site but wants Oracle as the backend (to handle the entire business from end to end, not just the webapp part) because he's been told that MySQL (and MS Access) will choke when the numbers start rising. .
    Facebook runs on MySQL. It would be impossible to use it if it didn't scale (granted, Facebook probably added some heavy modifications like it did with apache and PHP, but still...at its core, MySQL will scale).

    Oracle DB is overkill, the free version is limited and the full versions costs money, and many webapps don't run on it anyway.
    Visit The Blog | Follow On Twitter
    301tool 1.1.5 - URL redirector & shortener (PHP/MySQL)
    Can be hosted on and utilize your own domain

  5. #5
    SitePoint Enthusiast
    Join Date
    Sep 2012
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks ForceFlow, in that case, would you know when Oracle is used, if ever, and why, if all of its features are offered by MySQL (I mean, for ecommerce sites)?

  6. #6
    Utopia, Inc. silver trophy
    ScallioXTX's Avatar
    Join Date
    Aug 2008
    Location
    The Netherlands
    Posts
    9,067
    Mentioned
    153 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by maxdp73 View Post
    Thanks ForceFlow, in that case, would you know when Oracle is used, if ever, and why, if all of its features are offered by MySQL (I mean, for ecommerce sites)?
    I'm fairly certain the number of webshops running on oracle can be counted on one hand. It's like killing a fly with a missile; it doesn't make any sense.

    Oracle is mostly found in "enterprise" environments, i.e., large corporations.

    And I agree with others that MySQL should well be able to handle this volume. 100,000 orders a year ~= 11,4 orders an hour. A database has to be really poor to not be able to handle that. Hack, even SQLite should be able to handle that if you ask me.

    If you want an alternative you can also look at PostgreSQL, which in my opinion is faster and in my experience more stable than MySQL. Plus it supports master-master replication (MySQL only supports master-slave), which is good for scaling.

    Oh, and twitter also runs on MySQL. I wonder why people say it doesn't scale, it clearly does.
    Rťmon - Hosting Advisor

    SitePoint forums will switch to Discourse soon! Make sure you're ready for it!

    Minimal Bookmarks Tree
    My Google Chrome extension: browsing bookmarks made easy

  7. #7
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by ScallioXTX View Post
    I wonder why people say it doesn't scale
    because once upon a time eleven years ago, they had a few beers with the guy in the office across the hall and he said they couldn't get it to work
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  8. #8
    SitePoint Enthusiast
    Join Date
    Sep 2012
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    because once upon a time eleven years ago, they had a few beers with the guy in the office across the hall and he said they couldn't get it to work
    Ok, with such strong support for MySQL, I think I can go back confidently to the client...thnx to u all !


Bookmarks

Posting Permissions

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