Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    19

    Unanswered: Advice about InnoDB vs MyIsam

    Hi,
    Need advice in regard to choosing MySQL storage engine:

    I'm siding with InnoDB because I'm doing a project for my little company and security/reliability is a serious issue. Plus it supports transactions. The downside is it doesn't support fulltextindexing (which in my project might be kind of useful). Could you help?

    Thanks,

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if you need fulltext indexing then make that table MyISAM
    or
    push the columns that you need fulltext indexing on into another table
    retain the MyISAM on the old table, and implement a one to one realtionship through software.

    enforcing relationl integrity through INNODB is fine, its easier, but there is no reason why you cannot do effectivley the same task under software.. thats the old way of doing things, and it can be just as effective PROVIDING every piece of software writing or modifying that table behaves and sticks to the rules that it implements RI.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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