Return-Path: Delivered-To: apmail-directory-dev-archive@www.apache.org Received: (qmail 47346 invoked from network); 13 May 2010 08:54:09 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 13 May 2010 08:54:09 -0000 Received: (qmail 16775 invoked by uid 500); 13 May 2010 08:54:08 -0000 Delivered-To: apmail-directory-dev-archive@directory.apache.org Received: (qmail 16578 invoked by uid 500); 13 May 2010 08:54:06 -0000 Mailing-List: contact dev-help@directory.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Apache Directory Developers List" Delivered-To: mailing list dev@directory.apache.org Received: (qmail 16571 invoked by uid 99); 13 May 2010 08:54:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 13 May 2010 08:54:06 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.9] (HELO minotaur.apache.org) (140.211.11.9) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 13 May 2010 08:54:03 +0000 Received: (qmail 47318 invoked from network); 13 May 2010 08:53:41 -0000 Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1) by 127.0.0.1 with SMTP; 13 May 2010 08:53:41 -0000 Message-ID: <4BEBBE14.2050204@apache.org> Date: Thu, 13 May 2010 10:53:40 +0200 From: Stefan Seelmann User-Agent: Thunderbird 2.0.0.24 (X11/20100411) MIME-Version: 1.0 To: Apache Directory Developers List Subject: Re: About reverse index ... References: <4BE6D7CB.7020502@gmail.com> In-Reply-To: <4BE6D7CB.7020502@gmail.com> X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Emmanuel Lecharny wrote: > Hi guys, > snip > > So here is what I suggest : > - get rid of those reverse index > - or, at least, make it optionnal > > thoughts ? You described pure attribute value indices (including system indices like objectClass and entryUUID as well as user indices like cn or uid). I think for those indices it is possible to get rid of the reverse index table. However there are other indices: - alias - onealias - subalias - onelevel - sublevel - rdn For those indices it is more difficult to remove the reverse index table because the reverse() methods are used more often and the information can't be extracted from the entry. Kind Regards, Stefan PS: We also need to find out how to restructure the alias and one/sublevel indices. We now have an RDN index that allows renames/moves in O(1). But the update of the indices still takes more time.