Why don't you just always put a limit 1000 on it, do you ever need more than that?
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a search for a common word it is very slow, for example:
select count(*) from resources where match title,keywords against('common word');
might take over a minute if there are a 5,000 or so rows that match. I'm looking for a way to speed this up and I'm thinking about adding as stop words any word that occurs in more than 1000 records. is there a way to find these? or is there something else someone can suggest?
here are some of my variables: ft_boolean_syntax | + -><()~*:""& ft_min_word_len | 4 ft_max_word_len | 254 ft_max_word_len_for_sort | 20 ft_stopword_file | (built-in) key_buffer_size | 268435456 myisam_sort_buffer_size | 67108864
here is my table size on disk:
-rw-rw---- 1 mysql mysql 8976 Aug 27 10:20 resources.frm
-rw-rw---- 1 mysql mysql 134471560 Aug 28 09:33 resources.MYD
-rw-rw---- 1 mysql mysql 61629440 Aug 28 10:23 resources.MYI
any tips are appreciated. thanks, - Mark
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
