Hi Adi,
some general pointers: * Server version 7.9 is missing all the latest perf improvements, current version is 8.2.3 * You are accessing the files in the file system - try adding them to the database first, then you can make use of the text index etc. See http://docs.basex.org/wiki/Indexes#Text_Index
Regards,
Max
2015-09-04 8:31 GMT+02:00 Adi Babu adibabu.b@gmail.com:
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