Main > Forum/Website Discussion

Search sucks

(1/3) > >>

RayB:
Would it be possible for the Admins to contact the forum's authors and complain to them about the horrible search function?

I searched for some terms, and as an example to you, one of the words was "old". Well I got back results for words CONTAINING "old" (such as fold, hold, gold, etc). That's just ridiculous. And the advanced search has no option to limit the search to whole words only.

Thanks!
Ray B.

sirwoogie:
Actually, that was a setting I put in. Glad you like it so much ;)

Seriously, it was off due to a performance hit it takes on the search query. I played around with it, and I think I've cut the overhead down a bit. I've enabled the option so it will do whole word matches only.

Happy sailing

RayB:
If you turn it off again and we add quotes to words, would it behave any differently?

sirwoogie:
I turned it on, and I had to turn it back off. The cpu usage of mysql shot to 100% for a considerable length of time, and it slowed the overall system to much to be worth it. During testing it went faster, but when it's under heavy use, mysqld really takes a hit.

I'm not sure on the quotes.

RayB:
That's weird (the cpu usage). Sounds like poor programming. All they (the forum coders) have to do is add a space in front of each keyword. That pretty much excludes all word "portions" when doing a string to string compare.

Oh well...

Navigation

[0] Message Index

[#] Next page