PEAK XOOPS - FULLTEXT KEY in XOOPS in englishin japanese

Archive | RSS |
XOOPS
XOOPS : FULLTEXT KEY in XOOPS
Poster : GIJOE on 2006-07-15 05:05:48 (8933 reads)

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()

0 comments

Related articles
Printer friendly page Send this story to a friend

Comments list

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!