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