Sorry i haven't been around lately, been trying to learn the whole .NET thing and clockcrew.cc is sort of a ghost town now :\
I believe that taking out the LIMITs on the search query would slow it down, but i haven't done any benchmarking.
here's what I did to fix the highlighting problem:
on line 626 (approx) of search.php you will find:
Code:
if ($search[querystring]!="") {
$search[querystring]=urlencode($search[querystring]);
$highlightwords="&highlight=$search[querystring]";
} else {
$highlightwords="";
}
replace it with:
Code:
if ($search[querystring]!="") {
$search[querystring]=preg_replace("/ \-(.*) /"," ",$search[querystring]);
$search[querystring]=preg_replace("/ \-(.*)$/","",$search[querystring]);
$search[querystring]=str_replace("+","",$search[querystring]);
$search[querystring]=str_replace('"',"",$search[querystring]);
$search[querystring]=urlencode($search[querystring]);
$highlightwords="&highlight=$search[querystring]";
} else {
$highlightwords="";
}
i believe that would work, but the highlighting engine can't highlight phrases - I will get to work on fixing that, thats part of the underlying system not the search.php AFAIK
thanks for the kind words guys

oh and gmarik, wheres the thread you started on vbulletin.com?