Chamnap, I have a hunch you can get away with not using *s.
Michael Della Bitta ------------------------------------------------ Appinions, Inc. -- Where Influence Isn’t a Game. http://www.appinions.com On Tue, Jul 3, 2012 at 2:16 AM, Chamnap Chhorn <chamnapchh...@gmail.com> wrote: > Lance, I didn't use widcard at all. I use only this, the difference is > quoted or not. > > q2=*"apartment"* > q1=*apartment* > * > * > On Tue, Jul 3, 2012 at 12:06 PM, Lance Norskog <goks...@gmail.com> wrote: > >> &q2=*"apartment"* >> q1=*apartment* >> >> These are wildcards >> >> On Mon, Jul 2, 2012 at 8:30 PM, Chamnap Chhorn <chamnapchh...@gmail.com> >> wrote: >> > Hi Lance, >> > >> > I didn't use wildcards at all. This is a normal text search only. I need >> a >> > string field because it needs to be matched exactly, and the value is >> > sometimes a multi-word, so quoted it is necessary. >> > >> > By the way, if I do a super plain query, it takes at least 600ms. I'm not >> > sure why. On another solr instance with similar amount of data, it takes >> > only 50ms. >> > >> > I see something strange on the response, there is always >> > >> > <str name="command">build</str> >> > >> > What does that mean? >> > >> > On Tue, Jul 3, 2012 at 10:02 AM, Lance Norskog <goks...@gmail.com> >> wrote: >> > >> >> Wildcards are slow. Leading wildcards are even more slow. Is there >> >> some way to search that data differently? If it is a string, can you >> >> change it to a text field and make sure 'apartment' is a separate >> >> word? >> >> >> >> On Mon, Jul 2, 2012 at 10:01 AM, Chamnap Chhorn < >> chamnapchh...@gmail.com> >> >> wrote: >> >> > Hi Michael, >> >> > >> >> > Thanks for quick response. Based on documentation, "facet.mincount" >> means >> >> > that solr will return facet fields that has at least that number. For >> >> me, I >> >> > just want to ensure my facet fields count doesn't have zero value. >> >> > >> >> > I try to increase to 10, but it still slows even for the same query. >> >> > >> >> > Actually, those 13 million documents are divided into 200 portals. I >> >> > already include "fq=portal_uuid: kjkjkjk" inside each nested query, >> but >> >> > it's still slow. >> >> > >> >> > On Mon, Jul 2, 2012 at 11:47 PM, Michael Della Bitta < >> >> > michael.della.bi...@appinions.com> wrote: >> >> > >> >> >> Hi Chamnap, >> >> >> >> >> >> The first thing that jumped out at me was "facet.mincount=1". Are you >> >> >> sure you need this? Increasing this number should drastically improve >> >> >> speed. >> >> >> >> >> >> Michael Della Bitta >> >> >> >> >> >> ------------------------------------------------ >> >> >> Appinions, Inc. -- Where Influence Isn’t a Game. >> >> >> http://www.appinions.com >> >> >> >> >> >> >> >> >> On Mon, Jul 2, 2012 at 12:35 PM, Chamnap Chhorn < >> >> chamnapchh...@gmail.com> >> >> >> wrote: >> >> >> > Hi all, >> >> >> > >> >> >> > I'm using solr 3.5 with nested query on the 4 core cpu server + 17 >> Gb. >> >> >> The >> >> >> > problem is that my query is so slow; the average response time is >> 12 >> >> secs >> >> >> > against 13 millions documents. >> >> >> > >> >> >> > What I am doing is to send quoted string (q2) to string fields and >> >> >> > non-quoted string (q1) to other fields and combine the result >> >> together. >> >> >> > >> >> >> > >> >> >> >> >> >> facet=true&sort=score+desc&q2=*"apartment"*&facet.mincount=1&q1=*apartment* >> >> >> > >> >> >> >> >> >> &tie=0.1&q.alt=*:*&wt=json&version=2.2&rows=20&fl=uuid&facet.query=has_map:+true&facet.query=has_image:+true&facet.query=has_website:+true&start=0&q= >> >> >> > * >> >> >> > >> >> >> >> >> >> _query_:+"{!dismax+qf='.....'+fq='......'+v=$q1}"+OR+_query_:+"{!dismax+qf='......'+fq='.......'+v=$q2}" >> >> >> > * >> >> >> > >> >> >> >> >> >> &facet.field={!ex%3Ddt}sub_category_uuids&facet.field={!ex%3Ddt}location_uuid >> >> >> > >> >> >> > I have done solr optimize already, but it's still slow. Any idea >> how >> >> to >> >> >> > improve the speed? Am I done anything wrong? >> >> >> > >> >> >> > -- >> >> >> > Chhorn Chamnap >> >> >> > http://chamnap.github.com/ >> >> >> >> >> > >> >> > >> >> > >> >> > -- >> >> > Chhorn Chamnap >> >> > http://chamnap.github.com/ >> >> >> >> >> >> >> >> -- >> >> Lance Norskog >> >> goks...@gmail.com >> >> >> > >> > >> > >> > -- >> > Chhorn Chamnap >> > http://chamnap.github.com/ >> >> >> >> -- >> Lance Norskog >> goks...@gmail.com >> > > > > -- > Chhorn Chamnap > http://chamnap.github.com/