vBPicGallery Search Feature

[Greg]

We are currently testing a search feature for vBPicGallery. The tests so far show that we will be adding two indexes to the database.

We will be able to search on gallery titles or gallery text (description). The current queries in MySQL explain seem lean enough. However, testing in the outside world will be needed to back that up.

I'm trying to drop it in so it can be an add on now and part of the next release so we can get some testers. Anyone that can help out will be appreciated.

Thanks

[Greg]

Here is a test page in operation. vBPicGallery Photo Gallery Search (http://www.riderinfo.com/forums/vbpicgallery.php?do=list).

[dodgechargerfan]

Playing with that demo site, I found a few searched that didn't seem to work out right.

"Thunder Stars" in descriptions for All words
gave me 3 hits
the first was bang on
the second had Star and Thunder, but not "Stars" - close enough
the third had neither words

harely pan in descriptions for All words gave me a ton of hits - none of those that I looked at had the word pan in it. Why "pan"? I don't know. I'm testing a search engine, not buying a bike! :P


Cool stuff though. vPicGallery is still my favourite add on to vB.

[Roy Delfran]

I will make an assumption. Since the custom fields are built into the textbox, you can search for anything that may be in the custom fields.
And a related subject. Is the information in the text box stored in the SQL data base?

I would be happy to beta test this on my site. It is the feature that has been needed for me to use the gallery.

[DMH]

I’m no coding guru and I’m not sure what kind of feedback you’re looking for but I’d be willing to give it a go on my site.

[Greg]

I'm not shooting to compete with a google search. :p

This is simplistic. The title search will likely yield results far beyond the expected, but with the list in order to relevance. It's a simple index search.

The text or description search should yield more accurate results than the title search as it is a full text search.

Quick and dirty.

Anyone have 1000 or more galleries?

[DMH]

Anyone have 1000 or more galleries?


Doh! Count me out. If you need any help in the double digit galleries area I'd be more than happy to help. :D

Thanks for working on the search feature. I’m looking forward to the release.

[Greg]

It's not an absolute necessity, but it's a PITA to do this by hand for testing and I want good feedback from the effort. Bigger forums with larger galleries are needed to see if the queries hold up.

[vitoreis]

Wainting for this fot looooong time! When it's released?

(Thanks noppid!)

[Greg]

I was going to do it this week, but a few more bugs were found and we worked on them. I think we're close though. A few more days maybe.

[mhc1576]

Is the search limited to desc1 field?
Is it possible to add desc2 and 3?

[Greg]

It is limited to desc1 and won't be expanded to 2 and 3. desc2 and 3 are legacy stuff from back when. I would prefer to see them merged to be honest. But that would take a LOT of recoding. So, we are limited by that for those reasons currently.


We just added pagination to search results today too.

[Greg]

After much thought and many requests, we are working on changing the system so that desc1 2 and 3 are combined and that they are search able completely. It will basically be transparent to the members. In the future, there will be one input field, year make model.

So the stuff in desc2 and 3 will be combined into desc1 and they can then search it.