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:1:f929ee47ba] 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 ) ) [/code:1:f929ee47ba] 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:

Fx learning, Try under "Roys arena ".

Better late than never... FX, I know you found the link, but for future reference to those yet to read this thread, the link is here: http://forum.equis.com/viewtopic.php?t=3111

:oops: Somehow, I knew that was too easy. Sorry. Try this link: http://forum.equis.com/viewtopic.php?t=1849ely, the search index is looking for character sequences of at least 4 characters. So, BQ or B-Q won't do it. 'B-Q Indicator' won't do it either cause the space doesn't count. I found out the B-Q* won't do it either... probably for the same reason... it is followed by a space. Anyway, I do remember talking about B-Q previously and know that Roy, Wabbit and Jose are familiar with the topic. While we may not find your exact thread again, you can always ask a new question. Wabbit doesn't bite!

Just remembering the conversations. I try to follow all of the threads. Err... lucky.