Search results sorting

Flying Mullet · 07-05-2005, 04:28 PM

Would it be difficult to make search results sortable? i.e. you can click on the "Thread", "Thread Starter", "Forum", etc... header to sort your results by that column to make searching a little bit easier?

Agent Proto · 07-05-2005, 04:32 PM

I don't think it can work that way. Besides, the current search system works just fine! Why make it even more complex than it is already?

edczxcvbnm · 07-05-2005, 05:18 PM

I just want to see restrictions removed on what you search for having to be longer than 3 letters. Sometimes the word or thing is just that short damn it.

Flying Mullet · 07-05-2005, 05:34 PM

It shouldn't be too hard. You just have to add an "Order By" clause to the end of the sql string and then search again.

Yamaneko · 07-05-2005, 06:44 PM

It wouldn't be too hard to do that, no.

ed: reducing the size of searchable words increases the size of the search index.

edczxcvbnm · 07-05-2005, 08:24 PM

Search index? I don't quite understand. Isn't every post put into the database and when I search it goes through those posts in the database? I don't understand searching quite that well but that is how I have always done it. I may get more results but if it helps me to find what I want then awesome.

crono_logical · 07-05-2005, 08:56 PM

If I rebuild the search index, expect 6+ hours of forum downtime

What words are that short that you're searching for? I could add it to the length exception list if it's not something silly like "the"

And looking how searches are stored in the database, it might need a hack to do that sorting thing, despite being relatively simple, so not doing that

Yamaneko · 07-05-2005, 08:58 PM

Normally, every word of four or more characters automatically gets built into the search index after every post, unless an admin has disabled that function. After a major upgrade, though, like when we upgrade to vB 3.5.0, the search index has to be completely rebuilt. If we allow words smaller than four characters to be indexed, the search index becomes bloated. The entire point of a search index is so that searches can be performed quickly and with minimal stress on the database.

Flying Mullet Site Staff Cid's Knight this space for rent Location: Finding my monkey cage exit strategy	#1 Search results sorting Would it be difficult to make search results sortable? i.e. you can click on the "Thread", "Thread Starter", "Forum", etc... header to sort your results by that column to make searching a little bit easier?
07-05-2005, 04:28 PM

Agent Proto Former Staff Location: Root Beer Forum	#2 (permalink) I don't think it can work that way. Besides, the current search system works just fine! Why make it even more complex than it is already?
07-05-2005, 04:32 PM

edczxcvbnm Posts Occur in Real Time Location: The World	#3 (permalink) I just want to see restrictions removed on what you search for having to be longer than 3 letters. Sometimes the word or thing is just that short damn it.
07-05-2005, 05:18 PM

Flying Mullet Site Staff Cid's Knight this space for rent Location: Finding my monkey cage exit strategy	#4 (permalink) It shouldn't be too hard. You just have to add an "Order By" clause to the end of the sql string and then search again.
07-05-2005, 05:34 PM

Yamaneko ..a Russian mountain cat. Location: Los Angeles, CA	#5 (permalink) It wouldn't be too hard to do that, no. ed: reducing the size of searchable words increases the size of the search index.
07-05-2005, 06:44 PM

edczxcvbnm Posts Occur in Real Time Location: The World	#6 (permalink) Search index? I don't quite understand. Isn't every post put into the database and when I search it goes through those posts in the database? I don't understand searching quite that well but that is how I have always done it. I may get more results but if it helps me to find what I want then awesome.
07-05-2005, 08:24 PM

crono_logical Administrator Hypnotising you Location: Back in Time	#7 (permalink) If I rebuild the search index, expect 6+ hours of forum downtime What words are that short that you're searching for? I could add it to the length exception list if it's not something silly like "the" And looking how searches are stored in the database, it might need a hack to do that sorting thing, despite being relatively simple, so not doing that
07-05-2005, 08:56 PM