[basex-talk] optimize BaseX performance

[Kunal Chauhan]

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*
mail...@gmail.com
[+918655517141]