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:
    180
    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:
    180
    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:
    180
    Likes Received:
    126
    any help ?