XF 1.5 Is search index rebuild req'd after lowering minimum word length?

[Floyd R Turbo]

As the title says.

Not using enhanced search.

Thx

 

[Paul B]

No, it's not necessary.

 

[Floyd R Turbo]

Ok. I lowered it from 3 to 4 and then tried to search a 3 letter word and got an error - maybe it was too common then. Is that something that the Enhanced Search is better at?

 

[Paul B]

What was the error?

It's possible it was a stop word.

The FAQ in my signature has some information on the search functionality.

 

[Mike]

Just to clarify, if you're not using enhanced search, to change the minimum word length, it needs to be changed in MySQL's configuration. This will in turn lead to all full text indexes on the server needing to be rebuilt (within MySQL) or errors may occur. Only once this is done can you drop the minimum word length option in XF.

 

[Floyd R Turbo]

What was the error?

I don't recall, it was a while ago, and I was just thinking about it when reading something else

to change the minimum word length, it needs to be changed in MySQL's configuration. This will in turn lead to all full text indexes on the server needing to be rebuilt (within MySQL) or errors may occur.

So this is different from just rebuilding the search index. Would it be the same effect if I changed the mySQL setting, then rebuilt the search index via ACP (and checked the box for erase the old one)? Or is rebuilding in mySQL pretty quick comparatively?

 

[Mike]

Rebuilding the index in MySQL should be much faster and may be required (compared to rebuilding it in XF) to ensure that the internal structures are reflected correctly. Note this would apply to any full text index you have in any database; it's possible there are places outside of XF that use it.

 

[Floyd R Turbo]

So I'm told that if I install Enhanced Search, I don't need to mess with mySQL - I can lower the minimum word length and it will work just fine. Correct?

 

[Paul B]

Correct.
Or more accurately, that setting does not apply.