Engines, Fulltext Indexes, Transactions?
Posted by: Remington Seph
Date: November 12, 2009 02:36PM

I'm in the process of designing a database that should be able to incorporate fulltext searches. When inserting information into the database it is of absolute importance that all queries execute or none at all. This needs to make use of transactions. If I use the myIsam engine which supports fulltext indexes, I cannot perform transactions. Also if I use the InnoDB engine i'm unable to perform fulltext searches. Any suggestions? Workarounds?

Options: ReplyQuote


Subject
Written By
Posted
Engines, Fulltext Indexes, Transactions?
November 12, 2009 02:36PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.