If You need some elp You have to give us more details:
What version You use?
Does exist one fulltext index on title + keywords?
The schema and indexes.
The result of:
explain select count(*) from resources where match title,keywords against('common word');
I think index file size is small. I expect a size greater or equal than the data file
( 134 471 560 data << 61 629 440 of index).
Santino
At 12:32 -0700 28-08-2003, Mark wrote:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]