Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 85E3E200C68 for ; Wed, 19 Apr 2017 02:21:19 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 84527160BAC; Wed, 19 Apr 2017 00:21:19 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id CC04E160BA1 for ; Wed, 19 Apr 2017 02:21:18 +0200 (CEST) Received: (qmail 14168 invoked by uid 500); 19 Apr 2017 00:21:17 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 14156 invoked by uid 99); 19 Apr 2017 00:21:16 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Apr 2017 00:21:16 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 73CF11A0273 for ; Wed, 19 Apr 2017 00:21:16 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.121 X-Spam-Level: X-Spam-Status: No, score=-0.121 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id s47DRIabTuI3 for ; Wed, 19 Apr 2017 00:21:11 +0000 (UTC) Received: from mail-vk0-f53.google.com (mail-vk0-f53.google.com [209.85.213.53]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 6DF9E5F576 for ; Wed, 19 Apr 2017 00:21:11 +0000 (UTC) Received: by mail-vk0-f53.google.com with SMTP id j127so4625105vkh.0 for ; Tue, 18 Apr 2017 17:21:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-transfer-encoding; bh=OtfHzBM0AXdALdAL6yi4NQnIXEXD+ym0pXzyMmRcBzE=; b=a8zaLsyGb3B483ovYmMupz5NnxAum5wGRvVm3III4M3pVXtij55Yz081Bvm71dej0U gcqIKihtIZrclbrmKcl28F5uW9d5zapkQYnkcVpxaB4HzyE0osV/JTaVxXoyAoo9WJEJ Y+dvZg5zn2qiHgK0QTpAkXt4l+CPbxHX3MCzBqEaR/ypuS6+kVwxz3Ac5J0bcc1ILCbc ECEhuyCan8PR5Jo6FHhFzT1mJacXOg88ZAGQ5F9LMMk7QVlDoTK2mlMUW46YqQtwUSHf JFeUsK8mhpYNlotUf+ngiLbAM/Zc0zOjj/RY8Hl6q7caV37qotwTyV8sm0LSSbJiCVb/ /xdw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-transfer-encoding; bh=OtfHzBM0AXdALdAL6yi4NQnIXEXD+ym0pXzyMmRcBzE=; b=bsYeFJv3ymM8eVmmLda4GhJFe/X3z7KSCfJ3kIxcTjkV3VTK0GEesP7v/FyymS8qlt yRcDGG5foFtIdf5OOdsV1CgUAYfhmdgRAqcC/TsyAO2zqT/bVL11vaIVlBEiJ+ND7izw RgzPHOsot2LVJFiczS5zSi8rABliIPKxQBftsAaLf6MHTqONh8R35BWNWSdPzCM5EOq/ 2kISvrQPq91bE3frteBjOp7QYE9O5kQZJ2c6jeDA33ftr0+JglVitJRN4S0L947ycp9U 4AM9vQJoPLgaBETniciTn1zotv8MF1N8l7WTwPV963RgDRxkfZskbga7gK0SxKEbDFJv aZDg== X-Gm-Message-State: AN3rC/6pdjYDtGv2ebzSM/C/M2yDX2mpc7tbMcoGQ8rgIW5w+LOHf6GD J0G2tGvOHrtYi/UJY1Tr/kWmofi6/A== X-Received: by 10.31.164.198 with SMTP id n189mr60330vke.62.1492561265354; Tue, 18 Apr 2017 17:21:05 -0700 (PDT) MIME-Version: 1.0 Received: by 10.103.46.11 with HTTP; Tue, 18 Apr 2017 17:21:04 -0700 (PDT) In-Reply-To: References: From: Yonik Seeley Date: Tue, 18 Apr 2017 20:21:04 -0400 Message-ID: Subject: Re: prefix facet performance To: "solr-user@lucene.apache.org" Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable archived-at: Wed, 19 Apr 2017 00:21:19 -0000 How many unique values in the index? You could try facet.method=3Denum -Yonik On Tue, Apr 18, 2017 at 8:16 PM, Maria Muslea wrot= e: > Hi, > > I have ~40K documents in SOLR (not many) and a multivalued facet field th= at > contains at least 2K values per document. > > The values of the facet field look like: A/B, A/C, A/D, C/E, M/F, etc, an= d > I use facet.prefix. > > q=3D*:*&rows=3D0&facet=3Dtrue&facet.field=3Dconcept&facet.prefix=3DA/ > > > with "concept" defined as: > > > > > > This generates the output that I am looking for, but it takes more than 1= 0 > seconds per query. > > > Is there any way that I could improve the facet query performance for thi= s > example? > > > Thank you, > > Maria