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