This is part three of a series of posts about how the search process in phpBB works. In prior posts I have talked about the search table design and how to use stopwords. This post is going to describe how to roll back to code found way back in version 2.0.4 for one specific line. If you don’t implement this change you might see short words (two or fewer letters) or long words (greater than 20 letters) in your search database. This post also details a few additional tweaks that I have made to the clean_words() function found in includes/search_functions.php that help overall performance, both in posting and in searching. All of the changes I discuss in this post are available in MOD format. This is a bit of a long post, but stay with me, I think it’s worth it.
February 1, 2007
January 30, 2007
In a prior post I started reviewing the search process used in phpBB2. In summary, there are two tables involved. One table includes a set of words, each assigned a unique word_id value. The second table stores a cross reference of words and posts where that word appears. That makes searching for unique words very fast. It makes your search tables very large. In my opinion the best tool a board owner has to combat this is the stopwords file. This post will cover that file and how you can use it to tune searching on your board.
January 26, 2007
One of the most frequent
comments complaints about phpBB is the search process. For smaller boards it’s really not noticable. For larger boards (100K posts and above) it becomes very noticable. What is “it” that I am talking about?
The size of the search tables.