Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of chamnapchhorn@gmail.com
 designates 209.85.214.176 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPe6Lt0Jj27YA8WnYHtWOddtm+t+PqDJwbEeOkvT7O5JuKxAKw@mail.gmail.com>
References: 
 <CAMK8gA-P7c_oXx6J+iZ-GYsKKCrGpEU_AnGr6Acm09rFopBP8Q@mail.gmail.com>
 <CAPe6Lt0Jj27YA8WnYHtWOddtm+t+PqDJwbEeOkvT7O5JuKxAKw@mail.gmail.com>
From: Chamnap Chhorn <chamnapchhorn@gmail.com>
Date: Tue, 3 Jul 2012 00:01:22 +0700
Message-ID: 
 <CAMK8gA9F5foun+kcWjvE5bNGP5R4MkpjmO4odu+JRWCy1QJMKg@mail.gmail.com>
Subject: Re: How to improve this solr query?
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=f46d044481d992fa2704c3dbc0bb

--f46d044481d992fa2704c3dbc0bb
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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=3Dportal_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.bitta@appinions.com> wrote:

> Hi Chamnap,
>
> The first thing that jumped out at me was "facet.mincount=3D1". Are you
> sure you need this? Increasing this number should drastically improve
> speed.
>
> Michael Della Bitta
>
> ------------------------------------------------
> Appinions, Inc. -- Where Influence Isn=92t a Game.
> http://www.appinions.com
>
>
> On Mon, Jul 2, 2012 at 12:35 PM, Chamnap Chhorn <chamnapchhorn@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 se=
cs
> > 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=3Dtrue&sort=3Dscore+desc&q2=3D*"apartment"*&facet.mincount=3D1&q1=
=3D*apartment*
> >
> &tie=3D0.1&q.alt=3D*:*&wt=3Djson&version=3D2.2&rows=3D20&fl=3Duuid&facet.=
query=3Dhas_map:+true&facet.query=3Dhas_image:+true&facet.query=3Dhas_websi=
te:+true&start=3D0&q=3D
> > *
> >
> _query_:+"{!dismax+qf=3D'.....'+fq=3D'......'+v=3D$q1}"+OR+_query_:+"{!di=
smax+qf=3D'......'+fq=3D'.......'+v=3D$q2}"
> > *
> >
> &facet.field=3D{!ex%3Ddt}sub_category_uuids&facet.field=3D{!ex%3Ddt}locat=
ion_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/
>


--=20
Chhorn Chamnap
http://chamnap.github.com/

--f46d044481d992fa2704c3dbc0bb--