Dear Max, Currently I am using collection only(size 7.96 GB), I am sharing the query for your reference only. I tried the latest version 8.2.3 also but it takes more time than 7.9. Can you please assist me to proceed further.
Thanks & Regards, Adi
On Tue, Sep 8, 2015 at 9:15 PM, Maximilian Gärber mgaerber@arcor.de wrote:
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