View Single Post
  #5  
Old 10-07-2013, 03:42 AM
eva2000's Avatar
eva2000 eva2000 is offline
 
Join Date: Oct 2001
Location: Brisbane, Australia
Posts: 577
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

no demos but if you google for 'Digital Point modules: Sphinx-based search' the copyright from shawn's sphinx search link you will find vB forums using the plugin and get an idea of how fast search is

it's very fast ! alot of my private clients i setup vb4 digitalpoint sphinx search for and it's blistering fast for forums with up to 60 million posts from my own experience !

it isn't built inside specifically, search and search data are handled by sphinx search which you need to install from sphinxsearch.com on your server (hence why it isn't possible by default out of box - it's server software dependent on you installing and configuring properly sphinx search - just like vB is dependent on working apache, php and mysql setup) and search index data is usually on disk separately, default to /home/sphinx-data if you follow shawn's instructions but can be on any disk partition

edit: just quoting myself

Quote:
To give you an idea, I installed this vB4 plugin and Sphinx search http://sphinxsearch.com/about/sphinx/ on a 5.5 million post forum. The difference and load compared to default vB4 search is like night and day.

Before
- vB4 default search took around 57-60 seconds to return a common keyword search term of their forums which locks on MySQL tables affecting all other vB members usage of the forums.

After
- Sphinx search + vB4 sphinx plugin installed to replace vB4 default search, the same search term only took 0.18 to 0.30 seconds to return - that's 333x times faster! And without any negative effect for other vB members' experience on the forums.

Also reindexing search (needed create proper indexes for search terms - without this indexing your vB search feature will not return any results), for

- vB4 default search on 5.5 million post forum took around 3-5 days to reindex. Note while reindexing, majority of search keyword terms will not return any results until the keyword term is added to the indexing. So for 3-5 days search will be essentially broken to members not able to search for keyword terms.
- With Sphinx search plugin, it only takes around 10-15 minutes - that's 720x times faster!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01192 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete