I don't think there is anything you can do that won't require a full
table scan. I think some people break out the field they want to do a
full text search on into another table using the MyISAM format. So your
"core" table is InnoDB and your full text search fields are in a
related table that is MyISAM. This could actually help performance if
it then allows your "core" table to have fixed length records (i.e. no
varchar, text, etc.). But, of course, it all depends on your data and
how you can break it up.
On Aug 3, 2004, at 3:44 PM, Swan, Nicole wrote:
What is the best way to simulate a fulltext search on a MySQL table of
type InnoDB? Do I index the searchable fields and use the LIKE()
function with appropriate wildcards?
What are the performance implications with this? Switching back to a
table type of MyISAM is really not an option. Is there an "accepted"
way of dealing with this issue?
Thanks in advance for any tips,
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
