Hello,

I have a 1GB sized xml file.
which contains 94,50,001 records. 
while I fired query to retrieve all the records it will take approx 30 secs to execute a query.

I fired below mentioned query using Java API (QueryProcessor). 

"transaction/* except (/transaction/traInfo)"

              QueryProcessor proc = new QueryProcessor(query, context);
      
       Result result = proc.execute(); 
       System.out.println(result.size());
       
      Iter itr =  proc.iter();

it took 40 Secs on execution of the above code.
is there a scope of improvement without changing the query ?


My XML file is look like this.

<transaction>

<traInfo id="ti1">
<date>01-01-2014</date>
<source>bank1</source>
</traInfo>

<traInfo id="ti2">
<date>01-01-2014</date>
<source>bank2</source>
</traInfo>

<traInfo id="ti3">
<date>01-01-2014</date>
<source>bank3</source>
</traInfo>

<income transInfoRef="ti1">1000</income>
<assets transInfoRef="ti1">1000</assets>
<liablity transInfoRef="ti1">1000</liablity>
<grossprofit transInfoRef="ti1">1000</grossprofit>

<income transInfoRef="ti2">1000</income>
<assets transInfoRef="ti2">1000</assets>
<liablity transInfoRef="ti2">1000</liablity>
<grossprofit transInfoRef="ti2">1000</grossprofit>

<income transInfoRef="ti3">1000</income>
<assets transInfoRef="ti3">1000</assets>
<liablity transInfoRef="ti3">1000</liablity>
<grossprofit transInfoRef="ti3">1000</grossprofit>

...

</transaction>


--
Kunal Chauhan
mail4ck@gmail.com
[+918655517141]