Hi, I'm having problems with a fulltext indexed table where it takes a long time return from a query where many rows match. I noticed that when I run a query like select count(*) from table where keywords like '%x%';
it takes a long time but after that all fulltext queries are much faster, I'm not talking about cached queries here, and I'm guessing that it's because the index has been loaded into memory. but then after a while it slows down again. what do I have to do to keep this from happening? my key_buffer is bigger than the total size of my MYI's, and my table_cache is higher than my # of tables. I'm using 4-0-14 standard on Linux. thanks, - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]