Search function

Ezz · Post by **Ezz** » Mon Dec 01, 2008 5:26 pm

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

ChrisRLG · Post by **ChrisRLG** » Mon Dec 01, 2008 5:34 pm

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.

Ezz · Post by **Ezz** » Mon Dec 01, 2008 6:02 pm

Thanx, done that. Forum not to big, it took about 3 minutes to make the changes.

mpolito1969 · Post by **mpolito1969** » Thu Jun 11, 2009 9:18 pm

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

jorgefms · Post by **jorgefms** » Fri Jun 12, 2009 8:47 am

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

mpolito1969 · Post by **mpolito1969** » Fri Jun 12, 2009 9:05 am

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

advertisements