A *very* good search engine ?

[SecondSight]

Hello !

I have a very simple suggestion : I would like the Invision Power Board to have a search engine that would be able to search for 3 letters words (without having the server load to rise too high).

Is it possible ?

Thank you ! :)

[n-k]

I think you'd have to change the configuration of your MySQL server for that.

[bfarber]

Yeah, the limitation is with MySQL initially, and yes, changing it below 4 characters will drive the MySQL server load up, thus forfeiting almost all benefits of fulltext indexing in the first place.

[SecondSight]

changing it below 4 characters will drive the MySQL server load up

That's why I would like to have a new or improved system. :)

[bfarber]

Well....you COULD switch to MSSQL or Oracle.

Unfortunately if the limitation is with the software powering the website in the first place, there's next to nothing WE can do to change that. ;)

[Spirix]

Wasn't it an option to switch the search to a lower number? I though I did it for my site.

[bfarber]

If you use the Manual search option, you can change the search limitation to a lower number. Technically, you can do it for Fulltext too, IPB doesn't stop you - it's just that MySQL ignores anything smaller than the minimum fulltext word size and as a result, if you submit a 3 letter search it won't even do the search. You have to change your MySQL configuration first.