Main > Forum/Website Discussion

Search sucks

<< < (2/3) > >>

sirwoogie:
Unfortunately, it's not the forum software, it is the way mysql iterates through search criteria. The guys that wrote the forum software (mainly one developer in particular) are extremely proficient in PHP and SQL, so they've done as much as they can to tweak it out. The SMF software alone should attest to that (look at how fast this runs normally).

tommy:
I have to agree with  rayb i was looking for a thread on the x arcade joy and all i got was words with x like pleXi and such , theres no point in seaching on there

sirwoogie:
Well tell you what... I'll turn it back on and see what load we get. The first time I turned this on in production was during our /. flood and it tanked the server.

sirwoogie:
You know what, never mind, I'm turning this back off. Turning this thing on just sucks. Using a search pattern of "testing" with it turned on takes approximately 45 seconds and 100% CPU for that duration. With the option turned off it takes 2.3 seconds and 80% of the CPU for that duration. Part of the issue with search was its long lag time to return... I think that far outweighs the need for exact matches. The only thing I can suggest is try to limit to a certain group and time period. Otherwise, you'll get false positives.

SirPeale:
Can you explain exactly why exact words are so hard to pin down?  I have also had a real problem with searches due to some words being part of larger words.

Navigation

[0] Message Index

[#] Next page

[*] Previous page