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 CF37B200D52 for ; Sat, 18 Nov 2017 01:42:53 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id CDB43160C0A; Sat, 18 Nov 2017 00:42:53 +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 1E763160BFB for ; Sat, 18 Nov 2017 01:42:52 +0100 (CET) Received: (qmail 12725 invoked by uid 500); 18 Nov 2017 00:42:46 -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 12712 invoked by uid 99); 18 Nov 2017 00:42:46 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Nov 2017 00:42:46 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 45160180786 for ; Sat, 18 Nov 2017 00:42:45 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.129 X-Spam-Level: ** X-Spam-Status: No, score=2.129 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, 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: spamd3-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 (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id BiV-Z7Ry7pbg for ; Sat, 18 Nov 2017 00:42:43 +0000 (UTC) Received: from mail-wm0-f41.google.com (mail-wm0-f41.google.com [74.125.82.41]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 9E75B5FD14 for ; Sat, 18 Nov 2017 00:42:42 +0000 (UTC) Received: by mail-wm0-f41.google.com with SMTP id y82so5077733wmg.1 for ; Fri, 17 Nov 2017 16:42:42 -0800 (PST) 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; bh=ky3kYM6ZOF+T+a5rzGgWRsp/QRpJdNG9eWZ7JbbHUP0=; b=hbbUy0o8JeU758z4bqcojMx+6wBq5mmK81SDlx1nLcrozQMvjiAcs9oawKIcFnHnAg SmOqr1yv0EWwMXSihB+x94noKK8EYfZ/PcRjjenMdxU1UBQrI1hSY6h0M15oYZk3RYam +64xrZUdrjzgZsZ4qSLGLyH6T5m95ntS7qISFTw2xaMwnhHPY8o8Tn2lB2NmfuVXSG6P bw9NLAAorSP7/KpfavR4B51IBrXrgYaWNWnyfcjv6rXk4B4m647dGzaGpEdYvDvem/Yz V2RRTsxQiMldRTkMr5RkQg92IC7mqygiCU50aK+o12ViVwel5EwxSjWLm89K8JNFpDc2 xhSA== 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; bh=ky3kYM6ZOF+T+a5rzGgWRsp/QRpJdNG9eWZ7JbbHUP0=; b=CTGbkaCPiyee+Qt7yfTNAuwqAF/RxWq6+Xnc/lPen83pa7K88M3NJODfyX8H7pXZ7j 1fggade1yL65PCyaPrAZ/SaGt4bJ/cwpEPTeqiQHvh4mPbhmORWma4LJ7WpiCE3bUOqq C3cymTvCczUG3jAsAYEzYJ6h9rTnl6XTw2Rf+WBgR3pZ3jnHpYC/M1XWWmxMVQxtOo4k indKbnzjycBxQV7saAyngVabE7qkMmDXS3xWJySzgTE78ZaWkCmdQhLw2kSdXGdnlXNn YpijluNQUFb+WSa/YmHZYVQEoE3/2DOtmNGNFwnQ7/UOv2NuEWM+50jNsXX6PWhsHkEH mm2A== X-Gm-Message-State: AJaThX5s32TH15m0mfkC9AhPOPWPOUc5tQabYEkEcI9CiwPBUX5iXtwj kWOXTDNDvZtxxrSz2/qZV2uMV7C2VYbxX5ypXrU= X-Google-Smtp-Source: AGs4zMY8onDtLmJ6gIoHoaDUllRe3NpnF3HduareaqnL8VB8Zot+Q42kq+PePIdDYzUM7t9rqG2vtl8DPyd9Nj20Q0U= X-Received: by 10.80.164.87 with SMTP id v23mr431024edb.99.1510965761338; Fri, 17 Nov 2017 16:42:41 -0800 (PST) MIME-Version: 1.0 Received: by 10.80.157.134 with HTTP; Fri, 17 Nov 2017 16:42:40 -0800 (PST) Received: by 10.80.157.134 with HTTP; Fri, 17 Nov 2017 16:42:40 -0800 (PST) In-Reply-To: References: From: Amrit Sarkar Date: Sat, 18 Nov 2017 06:12:40 +0530 Message-ID: Subject: Re: Leading wildcard searches very slow To: solr-user@lucene.apache.org Content-Type: multipart/alternative; boundary="94eb2c198fd478f586055e372157" archived-at: Sat, 18 Nov 2017 00:42:54 -0000 --94eb2c198fd478f586055e372157 Content-Type: text/plain; charset="UTF-8" Sundeep, You would like to explore http://lucene.apache.org/solr/6_6_1/solr-core/org/apache/solr/analysis/ReversedWildcardFilterFactory.html here probably. Thanks Amrit Sarkar On 18 Nov 2017 6:06 a.m., "Sundeep T" wrote: > Hi, > > We have several indexed string fields which is not tokenized and does not > have docValues enabled. > > When we do leading wildcard searches on these fields they are running very > slow. We were thinking that since this field is indexed, such queries > should be running pretty quickly. We are using Solr 6.6.1. Anyone has ideas > on why these queries are running slow and if there are any ways to speed > them up? > > Thanks > Sundeep > --94eb2c198fd478f586055e372157--