Dear Team,
I am facing performance issue taking long time to execute the
Xquery in Basex(Client Server architecture), can you please guide me to optimize the query performance.

Below are the statistics & Basex server hardware specifications.

Statistics :
-------------
Total Records count : 6000000
Fetch count         : 10000
Hits Parallel hits  : 100
Time Taking         : 750 seconds
Architecture        : Client Server Architecture

Hardware Specifications of Basex Sever :
----------------------------------------------------------
Operating System         : Red Hat Enterprise Linux 64bit
OS Version : Linux 2.6.32
Hard Disk : 500 GB
Memory Capacity     : 16 GB Ram
Processor Family         : Intel (R) Xeon(R) CPU E5 -2680 V2
Processor Speed         : 2.80 GHz
Physical Processors     : 8
Virtual Processors/cores : 4
Server Version : basex 7.9

Note : I have attached the sample xml data and Xquery .


Thanks & Regards
Adi