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!

Region Caching not working [Apex 3.1]

465870Jul 18 2008 — edited Jul 18 2008
Hello All,

I am trying to use region caching (SQL report region) to save some time on a query. I have region set to Cached by User, condition=Always. I am certain that it is JUST NOT CACHING. Subsequent calls to the same region are taking the same time as the first time. Also, I ran the built-in APEX_APPLICATION_CACHING reports and nada-- no caching.

Are there certain conditions under which caching just doesn't work? Here are some that I wonder about which I have in my setup:
- the report region source is using a dblink to another db; the data is not local to APEX.
- i am calling the function via a js "doSubmit" function.

Would I need to enable page caching in order for region caching to work?
Would these cause caching to be ignored or skipped?

TIA for your help!
Jonathan aka Stumped in San Diego
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 15 2008
Added on Jul 18 2008
6 comments
1,291 views