Caveat with new search results Nov07 '05

I talked recently about modifications I made to my search results, for this site. By including feedback in the search results, I (seemingly) provided better access to any type of information, stored here.

As I explained how I did it, I realized there is a pretty noticeable hole.

Since I use two separate queries, I therefore use two separate relevance ratings.

Simply merging both results sets together (after the fact) doesn’t equally balance the relevance ratings.

As much as I like feedback being searchable, it shouldn’t be given a higher relevance rating than actual posts, which is what’s happening now.

The way I have it now - both posts and feedback are weighed the same. Since each query applies the relevance rating - two separate queries means two separate relevance ratings - with no correllation between the two.

I am working on a solution to fix this, but I don’t see any obvious answers, as of yet.

Categories: Search , SQL

Add Feedback (view all)

Leave feedback

Feedback

Input format: The editor controls below will assist with Markdown syntax.

Status

Sub-status

Your info

You might want to take a look at the UNION command in SQL. With it, you can select data f ... Read more.

Indeed, Jennifer - that would be my answer! Thanks for pointing that out. Only problem... upon checking just now - my server's current versi ... Read more.

Ooops, no - I'm wrong. UNION is supported in versions 4, and up. So I'm set! ... Read more.

matthom is published and produced by Matt Thommes - an independent publishing enthusiast, mobile blogger, content creator, informative writer, web developer from Chicago. Never one to conform, Matt intends to promote the effect the web has on our lives, in an effort to intensify, instruct, and clarify all that is happening around us.

Contact Matt

Similar Entries

Stats

2 unique visits since December 2008

Syndicate

Advertisements