[WotC_Tech]

I've installed this hack and are having good luck with it on vB 3.0.3 with 3 million posts. I did have a performance problem when searching for posts in forums rather than searching against all posts. It appears that Erwin's Add-On helped us a great deal when searching against all posts, but queries against specific forums would often take 30 or more seconds to complete.

We resolved this issue by modifying Erwin's Add-On a bit:

PHP Code:

// Erwin's Add-On

$searchlimit = " WHERE";
$searchforumadd = "";

if ($searchthread) {
$searchlimit = " WHERE post.threadid=$searchthreadid AND";
}

if ($forumchoice) {
$searchforumadd = ", forumid";
// Modified by WotC_Tech
//$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid WHERE forumid IN($forumchoice) AND";
$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid AND thread.forumid IN($forumchoice) WHERE";
}

$fulltext_sql = "SELECT postid$searchforumadd FROM post$searchlimit MATCH (".$what_field.") AGAINST ('$query".$isboolean.") LIMIT 0, ".$vboptions['maxresults'];

// Erwin's Add-On 


It appears that the MySQL optimizer isn't doing its job and running the query as fast as it could.