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