Hi Christian,

how to print QueryInfo through Java API ?

I checked query in BaseX GUI and over there it shows Total time : 21 secs.
What else do I need to check in QueryInfo panel ?

apart from this following is my DB info.

Indexes
 Up-to-date: true
 TEXTINDEX: true
 ATTRINDEX: true
 FTINDEX: true
 LANGUAGE: English
 STEMMING: false
 CASESENS: false
 DIACRITICS: false
 STOPWORDS: 
 UPDINDEX: false
 MAXCATS: 100
 MAXLEN: 96

and also I observed several timestamp in my code. which are I am sharing with you.

               QueryProcessor proc = new QueryProcessor(query, context);
       
        Result result = proc.execute();     //  took  time : 21259 mili secs
        System.out.println(result.size());
        
       Iter itr =  proc.iter();

               while((item = itr.next()) != null){
     if(count >= start)
      System.out.println(/*item.serialize()*/);
     count++;
     if(count > end)
     break;
  
       }    //  loop took 18 More secs to complete.

total time taken is 40 secs for following query.

"transaction/* except (/transaction/traInfo)"


-
Kunal


On Thu, Aug 21, 2014 at 7:29 PM, Christian Grün <christian.gruen@gmail.com> wrote:
Hi Kunal,

we need more information to help you here. How does your query look
like? Does it benefit from index structures (please check out the
output in the QueryInfo panel)? Are your index structures up-to-date?

> while I fired query to retrieve all the records it will take approx 30 secs
> to execute a query.

> System.out.println(result.size());

Just in case: printing something to stdout takes often much more time
than evaluating the query.

Christian



--
Kunal Chauhan
mail4ck@gmail.com
[+918655517141]