Page 1 of 1

Search function

Posted: Mon Dec 01, 2008 5:26 pm
by Ezz
Hi everybody, I have a question regarding searh function. When I search for a word the search engine "explains"

The following words in your search query were ignored because they are too common words: krema.

I guess this is a limitation on number of post containing the shearched word...
Can it be changed to a higher value?
Is there something to be done about this problem?

Thanx ;)

Re: Search function

Posted: Mon Dec 01, 2008 5:34 pm
by ChrisRLG
adminCP > Search Settings > Common word threshold: = xxx%

Or switch to "Fulltext mysql" instead of "Fulltext native"

If you make those changes you will need to use the
adminCP > maintenance > Search Index
then use that to delete and rebuild the index.

Be aware that on a large forum the rebuilding of a search index can take a long time.

Re: Search function

Posted: Mon Dec 01, 2008 6:02 pm
by Ezz
Thanx, done that. Forum not to big, it took about 3 minutes to make the changes.
:D

Re: Search function

Posted: Thu Jun 11, 2009 9:18 pm
by mpolito1969
ChrisRLG wrote: Be aware that on a large forum the rebuilding of a search index can take a long time.
Can you make a guess about how much will it take rebuilding the index on this forum?

Code: Select all

Number of posts:  	292779 
Posts per day:  	880.40
Number of topics: 	10232
Topics per day: 	30.77
Number of users: 	569
Users per day: 	1.71
Number of attachments: 	550
Attachments per day: 	1.65
Database size: 	1198.91 MiB
Size of posted attachments: 	49.87 MiB
Database server: 	MySQL(i) 5.0.77-community-log
GZip compression: 	On
Board version: 	3.0.4
Orphan attachments: 	12
Ciao,
Max

Re: Search function

Posted: Fri Jun 12, 2009 8:47 am
by jorgefms
mpolito1969 wrote:
ChrisRLG wrote: Be aware that on a large forum the rebuilding of a search index can take a long time.
Can you make a guess about how much will it take rebuilding the index on this forum?

Code: Select all

Number of posts:  	292779 
Posts per day:  	880.40
Number of topics: 	10232
Topics per day: 	30.77
Number of users: 	569
Users per day: 	1.71
Number of attachments: 	550
Attachments per day: 	1.65
Database size: 	1198.91 MiB
Size of posted attachments: 	49.87 MiB
Database server: 	MySQL(i) 5.0.77-community-log
GZip compression: 	On
Board version: 	3.0.4
Orphan attachments: 	12
Ciao,
Max
Rebuild the index search in localhost. It´s more fast and with no errors.
Take a look in this:
http://www.phpbb.com/community/viewtopi ... &t=1484635

Re: Search function

Posted: Fri Jun 12, 2009 9:05 am
by mpolito1969
jorgefms wrote: Rebuild the index search in localhost. It´s more fast and with no errors.
Take a look in this:
http://www.phpbb.com/community/viewtopi ... &t=1484635
I read that topic but unfortunately I have an UMTS connection at home, I don't think I can easily move so many data up and down.

Anyway, if those tables only contain text their size should be easily reduced by compression. I'll make a try.

Thanks,
Max