Search should be "like '%keyword%' based or thesaurus

[Deepak Agarwal <da...@gmail.com>]

Hi All,

Our testing shows that if we use mysql 'like' to search over the keywords
the results takes much time due to database overhead. We are planning to
make a good list of thesaurus and use '=' operator to search over in
'where' clause.

Looking for your thoughts. Is it a good idea? or if you could share your
experience in ofbiz search system.

-- 
Thanks,
Deepak Agarwal,

Re: Search should be "like '%keyword%' based or thesaurus

["Robert G." <ga...@mercon24.de>]

I just can support you with information about solr integration and use...I
did it and it was rel. easy and is really, really powerfull..

*1. integrate into ofbiz as standalone application*
https://docs.google.com/viewer?a=v&q=cache:Ca-IWfMMasQJ:stragure.com/Faceted%2520Searching%2520for%2520Apache%2520Ofbiz%2520E-Commerce.pdf+&hl=de&gl=de&pid=bl&srcid=ADGEEShTAdA9qFkA_gQ_tBDmhoAxIYc2nAHLuReQI9naxM1OeHCiT401OGudiSGYkojx46iVUTg3jU6Iep-Pxi_soeFZTjPqLeupopgHp7YO7Nwd09gTdMN-rpYp8eRO9VMzZcFNbA49&sig=AHIEtbRmQoEU0kXhW-n6M5_6AypYHKmZ5w&pli=1

*2. Add the fields to your schema.xml*
for the first just take like 2 fields: productID and productName for testing
purpose

*3. Integrate the jar files from solr for solrj (java api for solr)*

*4. Write java methods to get needed data from entities (productId and
productName) and send to solr for indexing (solrj api)*

*5. test solr with a query like "q=productId:yourproductId" and check if you
get results*

--> That is the main thing for integration. After that you can get more data
you need from entities and add the corresponding fields to schema.xml

the last thing is just how to handle the results or queries in your
ecommerce application. I use for it jquery, ajax and javascript to make
direct solr requests without reloading the whole page (for product filter
and search-suggest-function)

for details ask here when you did a few steps




--
View this message in context: http://ofbiz.135035.n4.nabble.com/Search-should-be-like-keyword-based-or-thesaurus-tp4635304p4635308.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Search should be "like '%keyword%' based or thesaurus

[Deepak Agarwal <da...@gmail.com>]

Yes. ecommerce. and unfortunately I can not go for SOLR immediately and I
need to make sure that current search of ofbiz works for me.

However, I am still curious to know feedback about solr and how to
implement that (bigfish we can use if required)

On Fri, Jul 27, 2012 at 4:57 PM, Robert G. <ga...@mercon24.de> wrote:

> is it for ecommerce application?
>
> --> use solr
> (fast, flexible, dream :) )
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Search-should-be-like-keyword-based-or-thesaurus-tp4635304p4635305.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: deepak.agarwal@paxcel.net
> Mobile: +91 9910322604
>
>

Re: Search should be "like '%keyword%' based or thesaurus

["Robert G." <ga...@mercon24.de>]

is it for ecommerce application?

--> use solr
(fast, flexible, dream :) )



--
View this message in context: http://ofbiz.135035.n4.nabble.com/Search-should-be-like-keyword-based-or-thesaurus-tp4635304p4635305.html
Sent from the OFBiz - User mailing list archive at Nabble.com.