Choosing database engines

Discussion in 'MySQL' started by samyak, Feb 12, 2011.

0
  1. #1
    Hi guys,

    I am building a scraper and its going to add roughly about 20K of rows everyday on a table called 'tbl_posts'. What database engine should I choose for this specific table?

    Thanks
    Amit
     
    samyak, Feb 12, 2011 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Go for InnoDB. Make sure you know the InnoDB restrictions.
     
    mwasif, Feb 12, 2011 IP
  3. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #3
    If you are going to simply insert rows in table, you can go for MyISAM engine.
    If you need constant select / insert / update / delete on a table, then you need InnoDB.
     
    mastermunj, Feb 12, 2011 IP