Hi Mark,
Here are the stats I gathered.
I will try to load a much bigger file later this week. I will post
those stats as well when I am done.
Thanks,
Sreeni
********************* BEGIN *****************
Hardware: Dell Inspiron 800 / 512 MB
Software: Microsoft Win2K / JDK 1.4.0
Dataset Size: 16MB
Number of Documents : 373
Load Type: DOM
Collection Size: 7.46MB
Insertion Time : 125s
Index Populating Time: 5s 738ms
Index Size: 386KB
Retrieval Time : 210ms for any item with index/ 28 Secs without index
Dataset Size: 102.5MB
Number of Documents : 2389
Load Type: DOM
Collection Size: 37MB
Insertion Time : 770 secs
Index Populating Time: 32s 878ms
Index Size: 3.14MB
Retrieval Time : 210ms for any item with index/ 192 Secs without index
Dataset Size: 1025MB
Number of Documents : ~23890
Load Type: DOM
Collection Size: 432MB
Insertion Time : 770 secs
Index Populating Time: 6m 28s 258ms
Index Size: 26.258MB
Retrieval Time : 220ms for any item with index/ Didn't try without indexing
********************** END ****************
-----Original Message-----
From: Mark J. Stang [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 05, 2002 10:13 PM
To: [email protected]
Subject: Re: indexing/xpath query question
How did your speed comparison with and without the index go?
thanks,
Mark
Sreeni Chippada wrote:
> Mark,
> That worked.
> xindiceadmin xpath -c /db/lucent -q
> "//*/BILL_INVOICE.bill_ref_no[text()='2']"
> or
> xindiceadmin xpath -c /db/lucent -q
> "//INVOICE/BILL_INVOICE.bill_ref_no[text()='2']"
> gives the expected result.
>
> Really appreciate your help. Thanks to all who responded to the
> mails.
>
> -Sreeni
>
> -----Original Message-----
> From: Mark J. Stang [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 05, 2002 7:32 PM
> To: [email protected]
> Subject: Re: indexing/xpath query question
>
> Sreeni,
>
> I tried it using differernt formats and the only one that worked was:
>
> xindiceadmin xpath -c /db/customers -q "//*/[EMAIL PROTECTED]'Stang']"
>
> In my case, my collection is customers, I am telling it to search
everything
> starting at the root of the document looking for any tag named "name" that
> has an attribute "lname" with a value of 'Stang'. I had to put the
quotes
> around
> the whole thing. It didn't work any other way.
>
> Mark
>
> Sreeni Chippada wrote:
>
> > Thanks Tom.
> > But I still do not know why this does not work.
> > xindiceadmin xpath -c /db/test -q
> > /INVOICE/BILL_INVOICE.bill_ref_no[text()="2"]
> > Also tried using single quotes. Any suggestions? I tried from both
command
> > line and using the java api.
> >
> > Thanks,
> > Sreeni
> >
> > -----Original Message-----
> > From: Tom Bradford [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, March 05, 2002 3:00 PM
> > To: [email protected]
> > Subject: Re: indexing/xpath query question
> >
> > On Monday, March 4, 2002, at 01:13 PM, Sreeni Chippada wrote:
> > > I am new to xindice. I added a few documents as DOMs and ran
xpath
> > > query successfully. Then I added an index on the collection and ran
the
> > > query. It takes same amount of time.
> > >
> > > xindiceadmin ai -c /db/test -n BillRefNum -p
> > > /INOVICE/BILL_INVOICE.bill_ref_no
> >
> > The IndexManager should have thrown an error when you tried to create
> > this index, because the pattern that you used is invalid. This is a bug
> > in the IndexManager.
> >
> > Xindice indexing patterns *are not* XPaths, they are simple element,
> > attribute, or element/attribute combinations.
> >
> > You should have created your indexes like this:
> >
> > xindiceadmin ai -c /db/test -n BillRefNum -p BILL_INVOICE.bill_ref_no
> >
> > Read the Xindice Administrator docs for more information about Indexing
> > patterns.
> >
> > --
> > Tom Bradford - http://www.tbradford.org
> > Architect - XQRL (XQuery Engine) - http://www.xqrl.com
> > Apache Xindice (Native XML Database) - http://xml.apache.org/xindice
> > Project Labrador (Web Services Framework) - http://notdotnet.org
