[Aforo]

I trying to improving remove search post function...
function remove_search_post($post_id_sql)
includes / phpBB / functions_search.php

My problem is that the next query is very slow for my requirements:

Quote:

$sql = "SELECT word_id FROM " . SEARCH_MATCH_TABLE . "
WHERE word_id IN ($word_id_sql)
GROUP BY word_id HAVING COUNT(word_id) = 1";

I was thinking to improve it... but I think that there are other way: this query is used for getting the words that has only one time in the SEARCH_MATCH_TABLE, after this list is used for removing the words from "nuke_bbsearch_wordlist"

Only for this???

If this is true I can acept never deleting words from nuke_bbsearch_wordlist, and saving the first query.

SOmebody knows if my guess is OK?????