Forum Moderators: rogerd
I just wonder if community software (like ipb, vbb, phpbb) built-in search can do the job efficiently when the community website grows. My friend, who runs a large community website, is considering to purchase additional searching service (like google mini).
Thanks.
Board software typically tends to build a table of every word in every post, and use it as an index to the post content. Where the wheels can come off is that the INSERT performance of your db can suffer as this table grows, which can slow posting down a lot. But searching is reasonably efficient with this strategy.
Offloading the index maintenance to an appliance would be appealing, but it would be necessary to disable the native search implementation in the board software to realize the full benefit.
Not all boards use that search strategy either.
