Hi Basex,

We have written a xquery which runs on a collection containing 600 xml files and the size of collection is 670MB.when we execute the xquery the CPU utilization is going up to 30-40% and as the number of hits that comes for executing this queries at a time will be around 20-40 because of high CPU utilzation for executing one query the processing speed of the remaning queries is getting delayed.

Could you please check is some thing wrong in the query or do you have some suggestion which could improve the performance.Please find attachement of query and sample xml file.

Thanks & regards

Sateesh.A