Quantcast

Borked search

6thElement

Schrodinger's Immigrant
Jul 29, 2008
8,373
5,228
If it is broken and needs fixing, can I petition to have the default results be based on newest first? Rather than relevance, which seems to just show me stuff from 10 years ago, rather than the thread from last week I'm generally hunting for.
 

binary visions

The voice of reason
Jun 13, 2002
21,847
720
NC
I disabled enhanced search because it was causing the page to fail to refresh every time anyone posted something. It reverted back to the old style search which should still function, but it looks like it's not happy. I'm rebuilding the search index to see if that solves it.
 

binary visions

The voice of reason
Jun 13, 2002
21,847
720
NC
The indexes are rebuilt and it looks like the searches are happy now. The non-enhanced search is pretty mediocre but it'll work for the time being.
 

binary visions

The voice of reason
Jun 13, 2002
21,847
720
NC
How do the search indices work?
Caveat: I am not a database wizard.

My understanding is that SQL is poorly optimized for searching partial text within certain fields - e.g. finding the word "payload" inside each posts' contents. If the entire post were the word "payload" it wouldn't be a problem because it's fast to match an entire field, but that's not the case when searching a forum.

Building the search indexes create a full text index which is built against the individual words of the posts, which can be searched much faster.

Any more details than that and I'll have to call my database architect buddy to explain it to me before I relay it to you :D