I have a ViewCriteria "findByID1" created on a ViewObject "myVO". The mode for execution of this view criteria has been set "in memory".
Whenever I am applying the view criteria and executing, the calls on all the methods of ViewObject ( hasNext, getRowCount, next etc), it is taking invariably long time. I have checked multiple times and confirmed that the actual query with the where clause is not taking long time to fetch the results It is further suggested by the fact that sometimes, the ViewObject doesnt return any records, still the method calls take very long.
can anyone please suggest what might be a possible reason for this behaviour.
Any help appreciated.