Icy Phoenix :: View topic - Problem With DB Query And

Old Support Topics - Problem With DB Query And

Marfo [ Mon 03 May, 2010 16:13 ]
Post subject: Problem With DB Query And

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

Marfo [ Wed 05 May, 2010 18:36 ]
Post subject: Re: Problem With DB Query And

little up

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

spydie [ Wed 05 May, 2010 22:03 ]
Post subject: Re: Problem With DB Query And

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

Mighty Gorgon [ Sun 09 May, 2010 20:29 ]
Post subject: Re: Problem With DB Query And

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