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/
