Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted July 30, 200618 yr 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 ! :)
July 31, 200618 yr 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.
July 31, 200618 yr changing it below 4 characters will drive the MySQL server load upThat's why I would like to have a new or improved system. :)
August 1, 200618 yr 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. ;)
August 1, 200618 yr Wasn't it an option to switch the search to a lower number? I though I did it for my site.
August 1, 200618 yr 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.
Archived
This topic is now archived and is closed to further replies.