From users-return-4853-apmail-directory-users-archive=directory.apache.org@directory.apache.org Tue Oct 16 09:53:19 2012 Return-Path: X-Original-To: apmail-directory-users-archive@www.apache.org Delivered-To: apmail-directory-users-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D51BFD593 for ; Tue, 16 Oct 2012 09:53:19 +0000 (UTC) Received: (qmail 71695 invoked by uid 500); 16 Oct 2012 09:53:19 -0000 Delivered-To: apmail-directory-users-archive@directory.apache.org Received: (qmail 71557 invoked by uid 500); 16 Oct 2012 09:53:18 -0000 Mailing-List: contact users-help@directory.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@directory.apache.org Delivered-To: mailing list users@directory.apache.org Received: (qmail 71523 invoked by uid 99); 16 Oct 2012 09:53:17 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Oct 2012 09:53:17 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of elecharny@gmail.com designates 209.85.217.178 as permitted sender) Received: from [209.85.217.178] (HELO mail-lb0-f178.google.com) (209.85.217.178) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 16 Oct 2012 09:53:10 +0000 Received: by mail-lb0-f178.google.com with SMTP id o2so5070148lba.37 for ; Tue, 16 Oct 2012 02:52:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:reply-to:user-agent:mime-version:to:subject :references:in-reply-to:content-type:content-transfer-encoding; bh=eeWN8vzFuJtv08LQHAL3wzrJMFnjBY4UMZ8ywIjBjK8=; b=CBzwGPazj7vw04BbuvFXpWOa7JE0TyTxT/7tBEzVcHsTQyUq328Thwn8k/eyzuJW6N caSsM/KMvPB0OWFHmu1g3fXqGpLzdWT4kFtriKzRqTZHTjgVPtbO2/AdITB53oV+rJ6B gfO8avUy1IkjOPx2a/XAB1wwl13yHoX/IlyWa29LgnT2MA16Cy1lL0OLKFaAoWC3j6zG kbyi7GkrSPR4A8zuteJkpBqKhnI/YwbbelWH/cHMZriZSOx+vBEw8K5XKEAsRy65kXih Lmi/djE7BFxJ0aa4EJjo9Ukj3gdUD9bxLenYTUtqEkMDiI33c8yt2xYYCMw8sD0KQ3Sa xaRw== Received: by 10.112.48.200 with SMTP id o8mr3023552lbn.96.1350381170244; Tue, 16 Oct 2012 02:52:50 -0700 (PDT) Received: from Emmanuels-MacBook-Pro.local (lon92-10-78-226-4-211.fbx.proxad.net. [78.226.4.211]) by mx.google.com with ESMTPS id fe5sm2892204lbb.6.2012.10.16.02.52.49 (version=SSLv3 cipher=OTHER); Tue, 16 Oct 2012 02:52:49 -0700 (PDT) Message-ID: <507D2E71.7050801@gmail.com> Date: Tue, 16 Oct 2012 11:52:49 +0200 From: =?UTF-8?B?RW1tYW51ZWwgTMOpY2hhcm55?= Reply-To: elecharny@apache.org User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:16.0) Gecko/20121010 Thunderbird/16.0.1 MIME-Version: 1.0 To: users@directory.apache.org Subject: Re: Possible regression for substring search on indexes? References: <2BE7E81B77921F43A6A273C2DF2FA6A43CCCBB7016@IBSMBX.ibs-ag.com> In-Reply-To: <2BE7E81B77921F43A6A273C2DF2FA6A43CCCBB7016@IBSMBX.ibs-ag.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org Le 10/15/12 11:52 PM, Carlo.Accorsi@ibs-ag.com a écrit : > Hi, we're using M9 built from the trunk on Wednesday of last week. We have our db setup as it has been for the past several months. There are 80k users. > > (sn=Thompson) returns in miliseconds > (sn=Thompso*) returns after 3-4 minutes. > > This seems very much like an issue we had back and in June (and was fixed). Any help is most appreciated. We need this build for all the good work Karin did on the password policy. > > Thank you, Carlo Accorsi > I have created a JIRA for this problem : https://issues.apache.org/jira/browse/DIRSERVER-1751 Since the extensive modifications I have made last month, I confirm that substring filters are not used during the evaluation and that leads to a full scan. This is my mistake, I'm working on fixing it atm. Thanks for the report ! -- Regards, Cordialement, Emmanuel Lécharny www.iktek.com