Re: [bdbxml] indexing help required

Manjeet Chaudhary wrote:
> The attribute number being incremented continuously ( in millions )
> I want perform a query on the document for the value of x depending on 
> number attribute's value
> as follows
> dbxml > query 'doc("container.dbxml/doc_name")/*/x[@number>10200 and 
> @number<=10220]'
> 
> this query executes in 1.5sec always
> i indexed the container for number attribute as 
> node-attribute-equallity-decimal
> but it gives the same result as the number attribute is being repeated 
> in the same block for each x node
> So please suggest me a suitable indexing strategy or an alternative 
> method to reduce the query execution
> time

I'm afraid that you will find that to be the case at the moment. If you 
can wait, the next version of DB XML will have better support for your 
problem, and is due to be released sometime in the next month.

If you can't wait, then I suggest you split your single document up into 
lots of smaller documents, each with only a few "x" elements. You should 
see a dramatic decrease in the time taken if you do this.

John

-- 
John Snelson, Berkeley DB XML Engineer
Sleepycat Software, Inc
http://www.sleepycat.com

Contracted to Sleepycat through Parthenon Computing Ltd
http://blog.parthcomp.com/dbxml


------------------------------------------
To remove yourself from this list, send an
email to [email protected]