lazy loading issue
619264Apr 13 2010 — edited Apr 13 2010Hello!
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!