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>