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/
