Hi Christian,

Thanks for your suggestion. It gave me considerable improvement.

Now, I am able to get query result in 13 secs and loop will be completed within half a sec. 
It's defiantly a remarkable achievement.

Still, is there any way to optimize this time ?

It would be great if you can explain me why the query and loop took so much time earlier and now it gets completed quickly.

Apart from this I have one concern that in my application XQueries will be provided by end users. 
So, every time I wouldn't be able to change or optimize the query.

does BaseX use any query optimizer  or can you suggest me any external tool / lib for the same ? 

Regards,
Kunal Chauhan




On Thu, Aug 21, 2014 at 9:11 PM, Christian Grün <christian.gruen@gmail.com> wrote:
>   transaction/* except traInfo

Sorry, this one was nonsense.



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