Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Doubt about Tunning View Objects

911689Aug 30 2013 — edited Aug 31 2013

Hi !. I have the following doubt about tunning View Objects:

If I have the following configuration on a VO:

All Rows

In Batches Of: 11

As Needed

Access Mode: Scrollable

Range Size: 10

Total Records On The Table: More than 100

What would happen is that while the initial render, the view cache is fetch with 11 rows from the table and the ui table shows 10. In subsequent scroll events, more queries again will be done but not when the user scrolls back. My doubt is this one: Why, while the initial render If I put a breakpoint in this overrided method executeQueryForCollection, the execution reachs there but in subsequent scroll events (forward) the execution doesn't reach there ?. I understand thast this should happen as the required rows are not yet in the cache. I would like to know a way to test this access mode and what method is executed in every roundtrip to the DB. Thankx !.

This post has been answered by Shay Shmeltzer-Oracle on Aug 30 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 28 2013
Added on Aug 30 2013
2 comments
173 views