Alright I have taken some new steps/came up with a new idea.
I will create a scheduled job on the database to run evey night which will clean up the search tables without rendering them useless.
Here is the script ( I'm using MS SQL), I know there are plenty of Systems Admin and such on the forum, don't be shy if you have a suggestion ;)
I will set this up as a stored procedure and schedule it to run at night every day around midnight.
Code:
DELETE FROM search_wordmatch
WHERE word_id in
(
Select Distinct word_id
FROM search_wordlist
WHERE (
word_text like '____' or
word_text like '___' or
word_text like '__' or
word_text like '_' or
word_common = 1
)
)
What this will do is remove any common word or any word that are less than 4 characters from the search wordmatch table.
I will rebuild the search tables slowly in the next few days, but starting, let's say next monday, check out the search function and let me know if you see improvements on both the search function and the speed of the forum.
Patrick :mrgreen:
My Site