Whats the workaround for implementing fulltextsearch with innodb?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gomzi
    Contributor
    • Mar 2007
    • 304

    Whats the workaround for implementing fulltextsearch with innodb?

    Hi,

    I would like to know if you guys are aware of any workaround for implementing something similar to a fulltextsearch when the engine is innodb.

    As I understand it, innodb doesn't support fulltextsearch. So, how exactly should one go about it.

    Thanks.
  • mwasif
    Recognized Expert Contributor
    • Jul 2006
    • 802

    #2
    Originally posted by gomzi
    As I understand it, innodb doesn't support fulltextsearch.
    You are right.

    Do you really need to InnoDB engine?

    Comment

    • gomzi
      Contributor
      • Mar 2007
      • 304

      #3
      Originally posted by mwasif
      You are right.

      Do you really need to InnoDB engine?

      Yes. I would like to use the foreign key feature that innodb provides.

      Comment

      • mwasif
        Recognized Expert Contributor
        • Jul 2006
        • 802

        #4
        Originally posted by gomzi
        Yes. I would like to use the foreign key feature that innodb provides.
        Can't you handle them in your application?

        Comment

        • gomzi
          Contributor
          • Mar 2007
          • 304

          #5
          Originally posted by mwasif
          Can't you handle them in your application?
          Yes. It is possible. But maintaining consistencies across the tables wont be that easier. Also, I wont be able to use on delete/update cascade and such other things.

          Comment

          • mwasif
            Recognized Expert Contributor
            • Jul 2006
            • 802

            #6
            There is no work around for implementing FULLTEXT in InnoDB AFAIK.

            Comment

            Working...