Eyes on Final Fantasy Forums > Reference > Feedback Forum > Asinine search error

[Big D]

Apparently, searches can indeed put a lot of strain on resources. LiveJournal had a lot of problems with that, where significant slow-down was caused by even a few people searching. It's kinda understandable, since the software's gotta trawl through every single piece of text whenever someone hits 'search'. It's also understandable that searches for shorter words would cause more problems, too, since smaller groups of letters are statistically more likely to crop up, not to mention the effect of wildcard characters.

:edit: Everything I just said has already been explained by others. Never mind

[Del Murder]

Well I set the character limit to 3 in the Admin CP and tried a search and it didn't work, and that's about the extent of my ability there.

[edczxcvbnm]

Originally Posted by Roto13 ^

I searched for "Final". Did I break anything?

Maybe

Showing results 1 to 50 of 50783
Search took 39.68 seconds.

[Roto13]

Mine got like 49,499 results. I thought that was a weird number. I'm going to try it again.

And again.

And again.

[Roogle]

Please do not run large searches or queries if you do not need the results.

[Citizen Bleys]

This is why you should not create a large red button that says "Don't Press" and crashes the forums if you press it.

That was the original plan for the Attack button.

[Samuraid]

Just some more info about this:

We can support 3 character searches. The reason the adminCP setting won't work is because we use a MySQL FULLTEXT index and it is configured at the server level to only support 4-character words minimum. We can change this setting to 3 characters minimum and that would allow for shorter search words.

Also, the MySQL FULLTEXT index automatically ignores common words like "the" so no worries about them getting needlessly indexed.

This can be done, but it will increase the storage space required for the database though so that will be an important consideration.

[Del Murder]

I say do it.