[bdbxml] Sort Query Performance

M Chaudhary <[email protected]> Wed, 24 Aug 2005 12:47:07 +0530
Newsgroups gmane.comp.db.dbxml.general
Message-ID <[email protected]>
Hello friends ,
I am using dbxml 2.1.8 version .
I am executing a sort query on a container with more than 10000 
documents , but the execution
of the query is taking a lot of time(more than 15 mins).
The query is as follows --
 'for $i in collection("xyz.dbxml")/root/x order by $i/y[@a="abc"]/@b 
descending  return $i'

I have indexed the container as follows : -

Index: node-attribute-equality-string for node {}:id
Index: node-attribute-equality-string for node {}:a
Index: node-attribute-presence-none to node: {}:b

and the Xml Structure is as follows --


------XML structure ------

 <root id = "pqr" >
        <x>
            <y a="abc" b="300"> </y>
        <y a="def" b="123"> </y>
        <y a="pqr" b="432"> </y>
        ...
        ...
    </x>
    ...
    ...
    ...
    ...
 </root>


 Can you please suggest me what should I do make the query execution 
faster ?
 Thank You !
 Regards ,
 Ajinkya N


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