Notices

Improve Search Results and Performance With MySQL Full Text

 
 
 
 
Old 01-05-2012, 05:30 PM
  #1  
Maude Rater
Thread Starter
iTrader: (15)
 
paimon.soror's Avatar
 
Join Date: Jun 2010
Location: Between Cones
Posts: 7,562
Received 14 Likes on 13 Posts
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.

Here is a page that can help set up this search function:
https://www.vbulletin.com/docs/html/main/search_type
paimon.soror is offline  
Old 01-05-2012, 05:34 PM
  #2  
Moderator Noir
iTrader: (4)
 
alnielsen's Avatar
 
Join Date: Aug 2004
Location: Buddhist Monastery, High Himalaya Mtns. of Tibet
Posts: 12,257
Received 1 Like on 1 Post
Good luck with that.
alnielsen is offline  
Old 01-05-2012, 06:03 PM
  #3  
Maude Rater
Thread Starter
iTrader: (15)
 
paimon.soror's Avatar
 
Join Date: Jun 2010
Location: Between Cones
Posts: 7,562
Received 14 Likes on 13 Posts
Not much any general user can do .... up to your site administrator to take care of it.
paimon.soror is offline  
Old 01-05-2012, 06:34 PM
  #4  
Administrator
 
zoom44's Avatar
 
Join Date: Jul 2002
Location: portland oregon
Posts: 21,899
Received 89 Likes on 66 Posts
Attached Thumbnails Improve Search Results and Performance With MySQL Full Text-search.png  
zoom44 is offline  
Old 01-05-2012, 06:41 PM
  #5  
Maude Rater
Thread Starter
iTrader: (15)
 
paimon.soror's Avatar
 
Join Date: Jun 2010
Location: Between Cones
Posts: 7,562
Received 14 Likes on 13 Posts
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.
paimon.soror is offline  
Old 01-05-2012, 06:42 PM
  #6  
Administrator
 
zoom44's Avatar
 
Join Date: Jul 2002
Location: portland oregon
Posts: 21,899
Received 89 Likes on 66 Posts
its been in this mode for at least 5-6 years
zoom44 is offline  
Old 01-06-2012, 10:54 AM
  #7  
Koi no Ousama
iTrader: (25)
 
TeamRX8's Avatar
 
Join Date: Apr 2005
Posts: 20,901
Received 327 Likes on 265 Posts
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 ...


.

Last edited by TeamRX8; 01-06-2012 at 03:48 PM.
TeamRX8 is online now  
Old 01-09-2012, 04:56 AM
  #8  
Koi no Ousama
iTrader: (25)
 
TeamRX8's Avatar
 
Join Date: Apr 2005
Posts: 20,901
Received 327 Likes on 265 Posts
apparently nobody is home ....
TeamRX8 is online now  
Old 01-13-2012, 06:32 AM
  #9  
Koi no Ousama
iTrader: (25)
 
TeamRX8's Avatar
 
Join Date: Apr 2005
Posts: 20,901
Received 327 Likes on 265 Posts
yeah, this web site needs more in absentia honorary moderators ...
TeamRX8 is online now  
 
 
 
 
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
Dokuji
Series I Trouble Shooting
8
11-01-2016 02:51 PM
ktec
Series I Wheels, Tires, Brakes & Suspension
5
12-10-2015 08:55 AM
AussieGray
RX-8's For Sale/Wanted
0
07-16-2015 03:58 AM


Thread Tools
Search this Thread
Rate This Thread
Rate This Thread:
You have already rated this thread Rating: Thread Rating: 0 votes,  average.

Quick Reply: Improve Search Results and Performance With MySQL Full Text


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service

© 2019 MH Sub I, LLC dba Internet Brands

We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.