MySQL Forums
Forum List  »  Full-Text Search

Re: Full text in INNODB
Posted by: Cornelius Sybrandy
Date: June 27, 2005 02:20PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
27837
June 21, 2005 02:34PM
16501
June 22, 2005 10:52AM
14508
June 23, 2005 06:13AM
12895
June 24, 2005 06:42AM
Re: Full text in INNODB
12583
June 27, 2005 02:20PM
11922
June 27, 2005 02:41PM
10838
April 14, 2008 03:51AM
13116
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.