1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Best Performance for Database Load

Discussion in 'Black Hat SEO' started by farhaty, Aug 24, 2011.

  1. farhaty

    farhaty Junior Member

    Joined:
    Jun 27, 2010
    Messages:
    179
    Likes Received:
    126
    Hi guys, I want to start a new venture with new project, the new project database will be huge, it will contains about 20 Millions rows. can you please advice me about what database should I choose? MySQL, MOngoDB, ... please help
     
    Last edited: Aug 24, 2011
  2. EvilPlankton

    EvilPlankton Junior Member

    Joined:
    Jun 16, 2011
    Messages:
    108
    Likes Received:
    20
    Mongo is very fast but there are trade-offs. It does not support standard SQL for querying and it does not support faceted search, which is quite common for guided search apps.

    MySQL will be a bit sower than Mongo, depending on the data model of course, but it fully supports SQL.

    You may want to consider SOLR if you will just be indexed-searching through the data, it supports facets and is very, very fast.
     
  3. johndea

    johndea Regular Member

    Joined:
    Jun 23, 2011
    Messages:
    308
    Likes Received:
    35
    Really depends on the workload. What will you be doing?
    A lot of writes? What kind of queries?
     
  4. farhaty

    farhaty Junior Member

    Joined:
    Jun 27, 2010
    Messages:
    179
    Likes Received:
    126
    I don't have any problem if it will too slow in writing mode, but I need it to be fast when I use 'SELECT * From .... WHERE'.... that's all
     
  5. farhaty

    farhaty Junior Member

    Joined:
    Jun 27, 2010
    Messages:
    179
    Likes Received:
    126
    any help ?