On Aug 27, 2007, at 9:38 AM, Cliff Hirsch wrote:
But the product table needs full text search capability, so I need the MyISAM engine.
I attended the MySQL Camp last week and the feeling I got was to stop using MyISAM for full-text searching and use one of the following options:
1. Zend_Search_Lucene (http://framework.zend.com/manual/en/ zend.search.lucene.html) 2. Sphinx (http://www.sphinxsearch.com) which was designed to integrate with MySQL but to search it, you run a separate daemon that php talks to.
Even the MySQL employees were saying that MyISAM full-text capabilities aren't very good.
-Rob _______________________________________________ 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
