Does this seem to weird to anyone?
mysql> SELECT count('') FROM emailarchive where match (sendername) against
('shawn') group by '';
+-----------+
| count('') |
+-----------+
| 13286 |
+-----------+
1 row in set (3.29 sec)
mysql> SELECT count('') FROM emailarchive where sendername like '%shawn%'
group by '';
+-----------+
| count('') |
+-----------+
| 13286 |
+-----------+
1 row in set (1.96 sec)
The more matches there are in a fulltext index search, the slower it gets
until finally at about 7,000 matches it actually becomes SLOWER than a
search with *no* index.
That leads me to believe that it's caused by the relevancy/weighting
routines, which leads me into my question...
Is there a way to completely disable the relevancy/weighting routines in the
fulltext index queries? I would really like to know either way so I can
stop stressing about it. :-)
- Shawn
-------------------------------
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858) 452-3696
---------------------------------------------------------------------
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
