vb.org Archive - Howto : Enable FullText Searching in vBulletin 3.0.2/3

Page 7 of 11

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3 Articles (https://vborg.vbsupport.ru/forumdisplay.php?f=187)

- - Howto : Enable FullText Searching in vBulletin 3.0.2/3 (https://vborg.vbsupport.ru/showthread.php?t=66789)

ShiningArcanine

07-08-2004 02:25 PM

Quote:

Originally Posted by dustyb

Duh, thanks. I indexed my database, enabled mysql full text, cleared the vB search index, dropped the word table, wrote in the quick hack for more optimized search by user name. All seems to be running smoothly (on a development server). I think resetting the mysql minimum word length from 4 down to at least 3 is going to be pretty standard procedure too.

But I guess the question begs... what's the benefit? I'm reading about some performance issues here on big boards. We have a small board (150K posts). I don't have the luxury of load testing this implementation, so it would be sort of trial by fire to launch it live. Are there any basic comparisons between vB search and mysql full text that I could measure right now? Query response times? Memory useage? Details?

If all of this just serves to reduce the size of the overall database, and eliminate the hassle of maintaining the cumbersome vb search index... and all other things from the user perspective remain equal... then I'm not so sure if it is really necessary at this point for us. Comments?

In my informal tests, fulltext is faster than the cumbersome vb search index.

dustyb

07-08-2004 04:40 PM

Zachery, just a follow-up... after implementing this "hack" what is your recommendation for ACP settings in the "Message Searching Options" and "Message Searching Relevance" options areas? Are any of these settings relevant when running with full text search? Would it make sense to turn anything off or adjust anything there to achieve greater optimization? Also, I assume you recommend clearing the old vb seach index, and for the supremely confident dropping the vbword table? Thanks.

Erwin

07-09-2004 02:47 AM

Quote:

Originally Posted by gorman

Freddie... is it possible to have some quick fix to speed up the current full text search option? I'm available to test things, as, as of now, I was forced to disable and there's no way I'm gonna reindex everything under the old option (yes, I emptied the search table, call me stupid, I know I am...). 2.5 million posts board, with 250+ users online...

Ahhh... with 2.5 mil posts, reindexing would take a couple of days. :(

Maybe install the vB3 fulltext search hack - it does work, and you won't have to reindex, and still utilize the fulltext (since you already have fulltext indexes on the post table).

M1th	07-11-2004 02:02 PM

Quote:

Originally Posted by gorman

Ditto, I'd be great if we could have a quick fix for this. I did what gorman did with the search table and now I'm stuck. :(

buro9

07-11-2004 09:27 PM

Quote:

Originally Posted by M1th

Ditto, I'd be great if we could have a quick fix for this. I did what gorman did with the search table and now I'm stuck. :(

I re-indexed!

But on my first go it escalated the load so high that my hosting company rebooted thinking something got out of hand.

I had to modify the admincp code so that the redirect paused 20 seconds... it took over 2 days to re-index all of my boards doing 250 posts with 20 second pauses.

What joy!

I think I'll stick with the old method until this is proven.

Nitesh

07-12-2004 09:16 AM

You dont need a quick fix or to re-index the search, just install the proper mysql search hack and that will sort everything out :)

Zachery

07-12-2004 05:22 PM

Quote:

Originally Posted by buro9

If you did the fulltext system you didnt need to reindex, mysql did that on its own

welo	07-18-2004 05:32 AM

Erm, Zachery? I haven't applied the 0.3 upgrade to my forum yet, but I did on a client's board and nowhere do I see in VB Options "Version Info and Other Untouchables". His is a totally unhacked board too (so far anyway). Any ideas?

Zachery

07-18-2004 06:38 AM

Quote:

Originally Posted by welo

You need to enable debug mode.

MrToasty

07-18-2004 01:28 PM

As mentioned earlier in the thread, the thread search doesn't seem to work with fulltext.. it simply retrieves results from the regular search...

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

Page 7 of 11

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01585 seconds Memory Usage 1,743KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: