[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]