Skip to Main Content

Developer Community

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Oracle Development Representative

Akash MishraFeb 2 2024

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.

Comments
Post Details
Added on Feb 2 2024
1 comment
61 views