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!

lazy loading issue

619264Apr 13 2010 — edited Apr 13 2010
Hello!

JDeveloper 11.1.1.2.0, ADF BC + ADF Faces + Oracle DB 11g
I've faced some kind of issue.
The view object (read access) with query "select * from table1" exposed from the data control on to the jspx page.

The table contains more than a million rows. The initial page load is normal. "Fetching data" is ok, the rows are displayed. Even the little scroll works ok.

But when I drag the scroll bar to the very bottom, I get "fetching data" for a long, long, long time. First time the IE crashed, next time it eventually displayed the 70000th row (approximately).
The scroll bar was in its end and didn't go below, like there was no more data. After that the scroll bar moves easily (within these 70 thousand rows) and table displays the data.

On the server side it looks like it aint lazy loading, but rather the full table load, because the database session contains a single query "select * from table1". It means that the whole data portion that can be read is in the cache.

So, my concerns are:

1. What if the at least 100 users run my application? Is the data of this big table going to be cached on the AS in the http session for each user?
2. So, what am I missing? May be there's some kind of BC configuration that can be set so that the data loading becomes more transparent to the user? Because everybody can be curious enough to scroll to the bottom. And then...

Thank you!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2010
Added on Apr 13 2010
1 comment
780 views