Your premium source for custom modification services for phpBB


HomeForumsBlogMOD ManagerFAQSearchRegisterLogin

Comments February 1, 2007

How does search work? Part III: Efficient clean_words() Function

Filed under: Search, phpBB — Dave Rathbun @ 2:04 am CommentsComments (2) 

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. :-)


Comments January 30, 2007

How does search work? Part II: Making Effective Use of “Stop Words”

Filed under: Search, phpBB — Dave Rathbun @ 9:58 am CommentsComments (7) 

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.


Comments January 26, 2007

How does search work? Part I: Table Review

Filed under: Search, phpBB — Dave Rathbun @ 11:46 am CommentsComments (11) 

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.


« Previous Page

Powered by WordPress