Skip to Main Content

APEX

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!

Interactive Grid load data only on focus (or delay loading)

Gerard OtinApr 25 2020 — edited Jun 23 2020

Hello everybody,

We're having a bit trouble with some queries that wait too long to load. We're trying to optimize it, but they're pretty complex. Meanwhile, we want to load data of IGs only when user focus the IG region.

We have one page with several IGs on it. Every IG is in one "tab" (Region Display Selector), and by default only one is showed.

We want to try to only load the data in IGs if the user clicks the tab. So, when the page is loaded, this should reduce database load even more (lazy loading is already set; and we have 10 tabs/IGs). They are all read-only.

I've been looking at everywhere, but I have not found any clues on how can I do this. Do you know any way?

Another alternative would be to delay the data-loading of the other grids.

Thanks all,

Regards.

Gerard.

Comments
Post Details
Added on Apr 25 2020
1 comment
803 views