Excuse me AGAINST is for fulltext MyISAM indexed search of records as InnoDB does not support AGAINST with fulltext.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of edward potter Sent: Thursday, November 30, 2006 4:46 PM To: MySQL SIG Subject: Re: [mysql] InnoDB and FULLTEXT may be a tip or 2 here, this is a new one for me: AGAINST "How-to: Full text search in MySQL" http://www.knowbies.com/vladimir-cvetic/databases/mysql/fulltext-search-mysq l/ On 11/30/06, Cliff Hirsch <[EMAIL PROTECTED]> wrote: > Why not just use two tables -- one InnoDB and one MyISAM -- and > write/update/delete both tables simultaneously? Twice the performance > hit, but it seems like a viable solution. > the Blog: http://www.utopiaparkway.com the Karma: http://www.coderswithconscience.com the Projects: http://flickr.com/photos/[EMAIL PROTECTED]/ the Store: http://astore.amazon.com/httpwwwutopic-20 _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
