Re: Full text in INNODB
Hello,
What I'm doing on a project is similar to what was stated above. My entire database uses InnoDB, however I added a single MyISAM table to store all of the text to be searched with the PK of the referenced item. I implemented this by adding an insert/update statement for the FT as the last query in my transaction. Though untested, this should allow me to rollback my entire transaction if an error occurs inserting into the FT table.
Casey
Subject
Views
Written By
Posted
27939
June 21, 2005 02:34PM
16568
June 22, 2005 10:52AM
14565
June 23, 2005 06:13AM
12961
June 24, 2005 06:42AM
Re: Full text in INNODB
12645
June 27, 2005 02:20PM
12000
June 27, 2005 02:41PM
10893
April 14, 2008 03:51AM
13202
July 06, 2005 08:18PM
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.