FULLTEXT KEY in XOOPS

Date 2006-07-15 05:05:48 | Category: XOOPS
in englishin japanese
There are some modules using "FULLTEXT KEY" in mysql.sql.
But I can find no queries with "MATCH()".
This makes useless indexes, and can harm its performance.

Moreover, MySQL does not support "splitting words" for multibyte language.

I will check the performance of ...

- "splitting words" by kakasi, chasen, or mecab
- implode the words by a space into a string
- stores the string into a column for searching
- query with MATCH()


You can read more news at PEAK XOOPS.
http://xoops.peak.ne.jp

The URL for this story is:
http://xoops.peak.ne.jp/md/news/index.php?page=article&storyid=138