Re: Full text and support for foreign keys?
Posted by:
Rick James
Date: August 16, 2010 11:16PM
Have your text in a MyISAM table with a FULLTEXT index. JOIN to the rest of the information in InnoDB tables.
Carefully order INSERTs so that you maintain some level of referential integrity; at worst having extra rows in the MyISAM table, but not missing any rows.
Subject
Views
Written By
Posted
6382
August 13, 2010 05:19AM
Re: Full text and support for foreign keys?
2903
August 16, 2010 11:16PM
2706
August 18, 2010 04:30PM
3453
August 18, 2010 09:04PM
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.