Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:06 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05169 seconds
  • Memory Usage 2,706KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (17)post_thanks_box
  • (17)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (17)post_thanks_postbit_info
  • (17)postbit
  • (17)postbit_onlinestatus
  • (17)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete