I remember reading something about where you have two copies of a
table... one is InnoDB where you do all of your write operations and
stuff like that and then the other is MyISAM so that you can do fulltext
searches to it. I can't remember how they got that to work... It may
have been by having two database servers and using replication to get
the data from the InnoDB master table into the MyISAM table.
I don't know much about this... but it looks interesting... says that it
supports InnoDB tables:
<http://www.sphinxsearch.com/features.html>
Also in my Google searching, I saw some rumors of FULLTEXT coming for
other storage engines in a future version of mysql:
<http://dev.mysql.com/doc/refman/5.0/en/faqs-mysql-cluster.html#qandaitem-26-10-17>
-Rob
Brian Dailey wrote:
Hey guys... let me start by describing what I need to do; maybe one of
you guys have been confronted with this before and have already come
up with an equitable solution.
I need to be able to do a 'fuzzy search' on names to check for
existing records on a name, accounting for mispelled names, etc.
The FULLTEXT index would work, probably, but it won't with an InnoDB
setup. Is there an alternative to this that I can use, or am I SOL?
Thanks,
- b.
_______________________________________________
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
