Re: [basex-talk] index usage while processing large xml file(s)

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