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
