Re: [bdbxml] Varying XQuery performance with change in 'return' clause
"Deepak Jois" <[email protected]> Fri, 24 Feb 2006 15:24:31 +0800
| Newsgroups | gmane.comp.db.dbxml.general |
|---|---|
| Message-ID | <[email protected]> |
Hi
It is getting a bit weirder. Here are two more queries I executed.
=3D=3D=3D=3D=3D
for $x in collection("genbank_bct.dbxml")/INSDSet/INSDSeq[INSDSeq_locus=3D"=
AE017283"]
return
$x
=3D=3D=3D=3D=3D
Returns instantly.
whereas,
=3D=3D=3D=3D=3D
for $x in collection("genbank_bct.dbxml")/INSDSet/INSDSeq
let $y :=3D $x/INSDSeq_locus
where $y =3D "AE017283"
return
$x
=3D=3D=3D=3D=3D
Takes extremely long!
The relevant index is : Index: unique-edge-element-equality-string for
node {}:INSDSeq_locus
Regards
Deepak
------------------------------------------
To remove yourself from this list, send an
email to [email protected]