Hi!
On Sep 17, Boris Cownie wrote:
>
> select count(*) from table match field against ('word1')
> select count(*) from table match field against ('word2')
> select count(*) from table match field against ('word2')
> ... etc ..
>
> The bad news is even these are slow if the word is common WHY ?
> The full text index should already know the single word count and return in
> a flash ?
> Is it still doing scoring and sorting in the count query on a single word -
> could I turn this off ?
You see, MyISAM index structure does NOT maintain a counter for every
index entry. So, the only way to found the number of index entries
corresponding to a particular word is to scan the index. That is, it's
fast to locate those words (due to b-tree structure) but scan time
is proportional to the number of words. :-(
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
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