Results 1 to 3 of 3

Thread: Enable FULLTEXT

  1. #1
    Join Date
    Nov 2003
    Location
    Sinapore
    Posts
    187

    Unanswered: Enable FULLTEXT

    Hello all,

    I've a table that stores forum messages. The message column uses InnoDB which, as far as I understand, does not support FULLTEXT. I would like to add a search feature to the forum and I'm wondering if I should convert the InnoDB engine to MyISAM to take advantage of its FULLTEXT capability.

    Another option I'm thinking of is to create another table that (sort of) mirrors the forum table, but which uses MyISAM. With this option, I can retain the original InnoDB forum table as I feel it's important to have Rollback capability.

    What is the best approach I should take?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i think you just answered your own question
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2003
    Location
    Sinapore
    Posts
    187
    Quote Originally Posted by r937
    i think you just answered your own question
    Thanks, r937

    Do you mean this one: Another option I'm thinking of is to create another table that (sort of) mirrors the forum table, but which uses MyISAM. With this option, I can retain the original InnoDB forum table as I feel it's important to have Rollback capability.?
    Last edited by pearl2; 09-23-07 at 23:49.

Posting Permissions

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