[bdbxml] indexing help required

Manjeet Chaudhary <[email protected]> Wed, 10 Aug 2005 17:34:48 +0530
Newsgroups gmane.comp.db.dbxml.general
Message-ID <[email protected]>
Hello Friends,
I need a help in following matter --
i have documents inserted in a container with a block as follows .

<x number="1">a</x>
<x number="2">f0a</x>
<x number="3">fa</x>
<x number="4">00a</x>
<x number="5">0100a</x>
<x number="6">10a</x>
<x number="7">0a</x>
<x number="8">0a0</x>
<x number="9">aaa</x>
<x number="10">a0a</x>
        ..
    ..
    ..
    ..

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

Thanks in advance
Regards
Manjeet Ch



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