shmax.com forums

Help us improve www.shmax.com => Bugs? On www.shmax.com? Ha ha, you kill me... => Topic started by: Wajo357 on September 23, 2013, 07:40:36 PM

Title: [RESOLVED]searching for browning
Post by: Wajo357 on September 23, 2013, 07:40:36 PM
searching for browning yields: http://shmax.com/products/1?browse=0&s=browning

It should only show 1 or 2 results...
Title: Re: searching for browning
Post by: engledogg on September 23, 2013, 08:13:26 PM
I think it's turning up "brown" results from "Browning" because of something called a stemmer.  If I'm not mistaken, that is something that can be turned off, right shmax?

MIKE
engledogg
Title: Re: searching for browning
Post by: shmax on September 23, 2013, 09:14:37 PM

I think it's turning up "brown" results from "Browning" because of something called a stemmer.  If I'm not mistaken, that is something that can be turned off, right shmax?

MIKE
engledogg


Yep, that's the stemmer in action. I can turn it off, but then we would lose all the wonderfulness it is doing (ie. finding "wolf" when you search for "wolves"). I think what I need to do is find some way to adjust the relevance such that exact matches (containing "browning") come first, but I'm gonna put this is sort of low priority for now, as I'm still deep in this big refactor I'm working on.
Title: Re: searching for browning
Post by: shmax on October 30, 2014, 10:24:11 AM
bump
Title: Re: searching for browning
Post by: shmax on October 31, 2014, 08:42:38 AM
I think the solution for this is going to be to switch things over to a commercial grade search product. We've done okay up until now with my own lame attempt at search, but it has a lot of drawbacks and there's no reason to go any further with it. I'll start researching some options.
Title: Re: searching for browning
Post by: Tripredacus on October 31, 2014, 10:03:27 AM
This works too, searching on Google

Code Select
site:shmax.com/product_details Browning
Title: Re: searching for browning
Post by: shmax on November 06, 2014, 03:51:44 PM
Still working on it. This is a tiny bug that requires an epic fix. I'll have more information soon.
Title: Re: searching for browning
Post by: Tripredacus on November 07, 2014, 08:14:11 AM
I wanted to note, regarding my google comment. Not everything is indexed on the site and not everything is as up to date. So using google might help, but it won't find everything for you.
Title: Re: searching for browning
Post by: shmax on November 07, 2014, 09:31:53 AM

I wanted to note, regarding my google comment. Not everything is indexed on the site and not everything is as up to date. So using google might help, but it won't find everything for you.


Naw, that's not what I meant by search product. I'll be integrating something internally (you end users won't notice anything different, other than slightly improved behavior), such as Solr, Sphinx, or one of the storage engines built into MariaDb (any of which are an improvement on the full text features already in use). I say the fix is epic, because using any of the above leads into upgrading the entire stack (OS, language, database) in use by shmax.com (which is currently in progress), and then I have to tear out the existing search stuff and rewrite it, all before the new Assassin's Creed games come out. 
Title: Re: searching for browning
Post by: shmax on November 10, 2014, 01:19:24 PM
The server upgrade is complete! We now have the latest versions of the OS, database, and scripting languages available. This has opened up a whole world of new possibilities for search, so I've moved on to exploring solutions to the stemmer/relevance problem we've been discussing.
Title: Re: searching for browning
Post by: shmax on November 11, 2014, 10:42:40 AM
Experiment #1 is live. Try searching for "browning", now...

http://www.shmax.com/products?topic=2346&q_filters_keywords=browning
Title: Re: searching for browning
Post by: Tripredacus on November 12, 2014, 09:07:30 AM

Experiment #1 is live. Try searching for "browning", now...

http://www.shmax.com/products?topic=2346&q_filters_keywords=browning


What is experiment #1.... adding a primary sort for results showing exact matches first, then showing the other matches afterwards?

It could be (maybe in the future) if a search result returns less than 3 items, there is an option to expand the search terms to a more generic result... although in the case of Browning, it may not be wise to return things with the color brown in them... But if, say, a result of 3 or fewer, a preview for the result of the shown results on the page. Let's say 10 items per page, search returns 3 matches, the other 7 would be "maybe you mean this" types. Just some ideas.
Title: Re: searching for browning
Post by: shmax on November 12, 2014, 09:48:33 AM

What is experiment #1.... adding a primary sort for results showing exact matches first, then showing the other matches afterwards?


Sorting by relevance. There's a lot of academics and math behind the relevance computation that I'm not even going to try to understand, but I'm able to nudge the scores with special operators. What I'm doing here is nudging the importance of the word's added stem downward, such that "brown" gets nuked by "browning".

As for your suggestion, it's a form of query expansion (http://en.wikipedia.org/wiki/Query_expansion), and is actually directly supported by the storage engine I'm using. So definitely doable; anybody want to second the motion?
Title: Re: searching for browning
Post by: Spiff-O-Matic on November 12, 2014, 06:52:12 PM
Probably too late to be helpful now, but on my site www.maperformance.com we use a search provider called SLI. It is very powerful... but I'm not sure what kind of cost tiers there are.

http://www.sli-systems.com/
Title: Re: searching for browning
Post by: Tripredacus on November 13, 2014, 10:21:33 AM

Probably too late to be helpful now, but on my site www.maperformance.com we use a search provider called SLI. It is very powerful... but I'm not sure what kind of cost tiers there are.

http://www.sli-systems.com/


Hmmm welp... it seems your site has the same problem.  ;D

(http://i85.photobucket.com/albums/k63/Tripredacus/screens/browning_zpsa7836d92.jpg)
Title: Re: searching for browning
Post by: shmax on November 13, 2014, 05:01:36 PM

Hmmm welp... it seems your site has the same problem.  ;D


It's not a problem, it's just stemming and it's generally a good thing. Even google does it (check the first link; the word "browning" doesn't appear): https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#safe=active&q=browning+chicken+blue+red

I'm experimenting with a more powerful search technology that has built-in stemming; more info soon.
Title: Re: searching for browning
Post by: Spiff-O-Matic on November 14, 2014, 08:50:04 AM
You cheeky fellow!  ::)
Title: Re: searching for browning
Post by: Tripredacus on November 14, 2014, 09:33:04 AM
Don't get me started on Google. They have gotten worse over the years.
Title: Re: searching for browning
Post by: shmax on November 18, 2014, 03:09:04 PM
Still experimenting. So far things are looking promising...
Title: Re: searching for browning
Post by: shmax on December 07, 2014, 02:01:29 PM
Sphinx is installed and on for good. Please make new bug reports for any weirdness you see going forward. Closing this one. Thanks, guys.