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
>