how to rebuild phpbb search engine

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
User avatar
zlisiecki
Registered User
Posts: 146
Joined: Fri Jan 25, 2002 1:38 pm
Location: Warsaw

how to rebuild phpbb search engine

Post by zlisiecki »

Hi, my search tables are quite big after 10 years forum activity.

phpbb_search_wordlist 394,235 MyISAM utf8_bin 27.2 MB with 20 MB for index !
phpbb_search_wordmatch 5,336,358 MyISAM utf8_bin 304.1 MB

My phorum is devoted to certain disease and i assume some 4 k terms is far enough. The rest (nearly 400 k now) regards the human language generally and not the disease only. The wordlist is obviously too big, the search eats too much processor power and it cannot be used any more.

Is there any possiblity to clean both tables, rescan the whole forum and build them again ?

Another question regards how to limit search engine generally only to some subfora. Does anybody know how to acomplish this ? I suppose writing an extenssion won't be too difficult.
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53464
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: how to rebuild phpbb search engine

Post by Brf »

In Manage Forums you can turn off Search Indexing in the settings for individual forums.
You can rebuild your search index by going into Maintenance / Search Index and delete the old index and re-create it. I do not know of a way you could select which words to index.
User avatar
zlisiecki
Registered User
Posts: 146
Joined: Fri Jan 25, 2002 1:38 pm
Location: Warsaw

Re: how to rebuild phpbb search engine

Post by zlisiecki »

Thank you Brf, .I'v overseen this possibility. I have set popularity treshold in the server configuration 10 % . Still I'll have nearly 100 000 words. The option could make sense to delete some words like "thank you".
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53464
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: how to rebuild phpbb search engine

Post by Brf »

If you want to reduce the number of words, you would reduce the popularity threshold, not increase it.
User avatar
zlisiecki
Registered User
Posts: 146
Joined: Fri Jan 25, 2002 1:38 pm
Location: Warsaw

Re: how to rebuild phpbb search engine

Post by zlisiecki »

Oh, I'v misundestood this. I thought for 0 % treshhold all words are included and the higher the treshhold the more popular words fall into this limit and won't be included. Is't it so ?
User avatar
Brf
Support Team Member
Support Team Member
Posts: 53464
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}

Re: how to rebuild phpbb search engine

Post by Brf »

By default, any word that appears in more than 5% of the posts is excluded.
You changed it to 10%, which means the word would have to appear in 10% of the posts, which is twice as many posts. You want to reduce it to 1%. Then it would exclude any words which appear in more than 1% of the posts.

Return to “[3.1.x] Support Forum”