You are currently viewing our forum as a guest, which gives you limited access
to view most discussions and access our other features. By joining our community, at no cost, you will have access to start new topics, reply to conversations, privately message other members (PM), respond to polls, upload content and access many other special features. Registration is free, fast and simple, so please join RX8Club.com today!
Improve Search Results and Performance With MySQL Full Text
So vBulletin has two options for searching, one is its internal index, and one is a mysql fulltext search. Larger forums MUST use the mysql fulltext search if you want the searching to be effective. By default, vbulletin has its internal search enabled.
Here is a quick rundown of the two:
Fulltext
Pros
Less PHP resources used because the indexing takes place in MySQL.
No need to maintain the postindex and word tables which can take up a lot of space.
Natural Language and Phrase searching is available.
Can Sort by relevancy for better results
Default search in vBulletin's latest versions.
Can support more searches per minute.
Searches can take better advantage of MySQL's query caching.
Cons
Less Flexible Indexing, especially on Shared Servers. Changing parameters requires shutting down MySQL, dropping indexes and rebuilding them.
Fewer control parameters within vBulletin.
Rigid Stopword list as an external file.
vBulletin Builtin Search
Pros
Not reliant on your MySQL version.
Can be easily manipulated in the Admin CP including adding words under the minimum character limit or changing that limit.
Cons
Resource heavy, especially building the index.
Indexing must be done before post is inserted to database and can result in errors on overwhelmed systems.
Search Results can cause database errors if there are too many hits.
Large tables must be maintained manually for proper usage.
No Natural Language or Phrase based searching.
Easy to bring down large boards with multiple searches.
__________________ Emissions and fuel economy haven't exactly been areas of strength for past rotary power plants, but absolutely no one with a soul has ever cared. - Autoweek
Rotary History:1982 RX7 GS, 1985 RX7 GSL-SE, 2004 RX8 Sport-Continuous Rotary Owner since 1985
Racing History:SCCA Solo II 1979-1986, Skip Barber Comp School 1983, SCCA Club Racing 1987-1993, 2004-2011 Track Days
Oh sweet, thanks for checking. Just see so many people bitching about search not being accurate that I have been digging around to find any way to help these people out.
If I had access to the closed "DIY: How to Search" sticky thread I could provide a number of helpful tips.
Of course the biggest problem of all has no real solution; none of the clueless noobettes on this site would any more look at it than any other sticky or information thread here.
Which BTW the DIY area needs another technical question thread flushing ...
.
__________________
Es gibt keine verzweifelten Lagen, es gibt nur verzweifelte Menschen.
- Heinz Guderian
Linear Mode
