Icy Phoenix

hi all,

Today our Host as sent us a mail where they say that the site where i'm a admin uses too much resources and if I won't that they block my site I've to solve this.

they say that the problem is in this query

SET timestamp=1272831401;
SELECT m.word_id
FROM ip_search_wordmatch m, ip_search_wordlist w
WHERE w.word_text IN ('bakuman', 'cercare', 'dovr<F2>', 'eater', 'esce', 'fior', 'immaginando', 'resistere', 'settimane', 'soul', 'stavo', 'tre')
AND m.word_id = w.word_id
GROUP BY m.word_id
HAVING COUNT(m.word_id) > 23705;

they told me that the problem is in the number of record analized, over 1,5 milions


how can I fix to this problem??

thanks and sorry for my bad english :mrgreen:

little up :oops:

i'm sorry but our hoster could block the site at any moment

have you tried fixing that problem going to

ACP-Database Management- Database Maintenance- Check search word list table.

That option removes unnecesary words from the list

Disable the search.php and use only gsearch.php.