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.lichtenber...@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 _______________________________________________ BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk