Eyes on Final Fantasy Forums > Reference > General Archive > Feedback Forum Archive > Search results sorting

[crono_logical]

It's already bloated, 8.1m entries in it

[Yamaneko]

Delete the index and start off with later post IDs. No one wants to search for Oldbie so-and-so's posts.

[edczxcvbnm]

I obviously have no clue how the searching really works on Vbullitin. I can't remember the words that I search for every now and then that are shorter than 4 words. Most of them are probably acryonims. I admit I don't use the search feature very much but when I do it seems to be a problem.

[crono_logical]

Yamaneko cried aloud with mirth and merriment:

Delete the index and start off with later post IDs. No one wants to search for Oldbie so-and-so's posts.

Still need a huge downtime, considering the skew of the distribution of posts over time towards more recently as the forum size grew rapidly

[Samuraid]

Sorting the search results probably wouldn't be too bad on the database, but it would likely require us to modify the vBulletin source code a bit which we are trying to stay away from doing.

As for setting the 3 character search limit... Yams is right, although vB's current method of using an external search table is old. Mysql has a built-in fulltext index that we should be using instead (unfortunately, vBulletin 3.5 needs to come out first) but even that limits words to 4 charaters or more.

[crono_logical]

Does mysql's built-in index allow you to do partial-match searches easily?

[Samuraid]

Like phoenetic matches?

I'm not perfectly sure, but I don't think so. You would probably need to create a metaphone/soundex index table for that.

[crono_logical]

Not phonetic, but I meant like cat*, basically wildcard matches