Return-Path: Delivered-To: apmail-xml-xindice-users-archive@www.apache.org Received: (qmail 17811 invoked from network); 6 Nov 2003 02:23:38 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 6 Nov 2003 02:23:38 -0000 Received: (qmail 92264 invoked by uid 500); 6 Nov 2003 02:23:17 -0000 Delivered-To: apmail-xml-xindice-users-archive@xml.apache.org Received: (qmail 92232 invoked by uid 500); 6 Nov 2003 02:23:17 -0000 Mailing-List: contact xindice-users-help@xml.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: Reply-To: xindice-users@xml.apache.org Delivered-To: mailing list xindice-users@xml.apache.org Received: (qmail 92220 invoked from network); 6 Nov 2003 02:23:16 -0000 Received: from unknown (HELO web60410.mail.yahoo.com) (216.109.118.193) by daedalus.apache.org with SMTP; 6 Nov 2003 02:23:16 -0000 Message-ID: <20031106022325.75956.qmail@web60410.mail.yahoo.com> Received: from [12.212.64.160] by web60410.mail.yahoo.com via HTTP; Wed, 05 Nov 2003 18:23:25 PST Date: Wed, 5 Nov 2003 18:23:25 -0800 (PST) From: matt ma Subject: Re: xpath with index after data is added does not work To: xindice-users@xml.apache.org In-Reply-To: <3FA98632.B38A2809@motorola.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N What version are you using Andrew? I'm using 1.1b1 and noticed that if you add index with -p *@id and you have id attributes in multiple levels of your xml file you will end up with no results on xpath quering [@id=?]. However, I was able to get this to work by specifying the level metatable/*/*@id xpath with this index does return results but no significant performance gain so I'm wondering if it works at all. For the indexes that work I am seeing significant performance improvements (~3x) for my db. I'm trying to figure out if indexes by design do not update themselves like they do in a normal database or if this is a bug. -matt --- Andrew White wrote: > Xpath with attribute indexes is (to the best of my > experimentation) broken. > I can't even get xindice to show results when I > delete and recreate the > index (works when deleted, putting it back breaks it > again). > > I also noticed that (when I first created the index) > I got about a 2x > performance gain on command line searches, but a > very slightly negative > effect on embedded searches. > > Anyone else? > > -- > Andrew White __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree