HI Adi,
     Have you tried Max's suggestion of adding the xml data to a BaseX db first? Based on this:

for $details in 
(collection("E:\Web-Projects\VodafoneUK\Docs\Cloud_Test_Stats\Performance_Analysis\Freq_Called_Sample_XML_Data.xml")

it looks like you're using the file Freq_Called_Sample_XML_Data.xml directly from the filesystem, which means it has no indexes and must be fully scanned to get results. You should create a DB and upload that xml file with TEXTINDEX and ATTRINDEX enabled (which is the default).  You might need to run the OPTIMIZE ALL command after uploading the xml file, you can run the INFO DB command and it will show if your database has up-to-date indexes or not. Once you have a db, you can also use the GUI to check the query plan that's being used for a particular query.

Martín.

Date: Fri, 11 Sep 2015 18:37:05 +0530
From: adibabu.b@gmail.com
To: mgaerber@arcor.de
CC: basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Fwd: Re : Basex Query Optimization Support

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
>