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  

little up

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

____________
Out of Order

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

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON