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 — edited Feb 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.

Duplicate Post
This post has already been added here:
Duplicate question
Marked by L. Fernigrini 3 weeks ago
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Marked as duplicate
Added on Feb 2 2024
0 comments
21 views