dan wrote:
And here is the result (Extracted from the Log4j output): - Query.execute(): 9375-7484 = 1891ms
do you see an improvement here when you execute the query again. Initial queries can be quite slow because the hierarchy structure is resolved from the index but later cached which speeds up queries significantly.
- QueryResult.getRows(): less than 1 ms - RowIterator.nextRow(): 13234-9375 = 3859ms
that indicates that most of the time is spent in retrieving the values from persistent storage. Does your application really require to read all 2000 documents?
regards marcel
