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