Hi Nesh,
as Johannes indicated, it could help to explicitly specify all child steps to the PmtInf node.
Christian ___________________________
On Wed, Mar 13, 2013 at 7:38 PM, Johannes.Lichtenberger Johannes.Lichtenberger@uni-konstanz.de wrote:
On 03/13/2013 05:04 PM, EV Narasimham wrote:
Hi, I'm currently processing a 3GB xml file. Below is the Query that is being executed and the corresponding output
count(db:open("ASEPXML",
"A_SEPXML")/descendant::*:PmtInf[15]/*:CdtTrfTxInf/*:CdtrAgt/*:FinInstnId/*:BIC/text()) Output: 100000
And without specifying the wildcard prefix? The query plan suggests that it's not using the text-index. Furthermore I'd probably use:
count(db:open("ASEPXML", "A_SEPXML")/root/PmtInf[15]/CdtTrfTxInf/CdtrAgt/FinInstnId/BIC/text())
without the descendant-axis step. Without the prefixes however, the descendant-axis step should be rewritten to the explicit child steps (I guess).
kind regards Johannes
BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk