Hi,
Sander Pilon:
> FULLTEXT indexes are about 95% of the size of the table, and they can
> perform quite well or very slow, depending on what you do.
>
For my use (a trouble-ticket database), they behaved extremely poorly,
unfortunately. The tickets frequently are over a MByte in size, which
results in _really_ long insert times (five minutes), which (the way
MySQL currently is designed) slows down the queries in an unacceptable
way.
Fixing that would probably require a new thread for index maintainance,
an extra file for the fulltext index, and a sensible file format that
can be searched while being updated.
I rather like the relevancy algorithm. The insistence on only indexing
full words is more problematic, however.
--
Matthias Urlichs | noris network AG | http://smurf.noris.de/
--
Most people ignore most poetry
because
most poetry ignores most people.
-- Adrian Mitchell
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
