Sunday, December 11, 2011

JDev/ADF sample - Tuning ADF Tree - Retain View Link Accessor Rowset

  • Tuning ADF Tree - Retain View Link Accessor Rowset. When expanding ADF Tree node, by default - each time ADF generates new SQL statement to retrieve expanded tree level nodes. New SQL statement is generated even after collapsing and expanding same node. In most of the cases, especially when tree structure is static, we would like to avoid multiple SQL invocation for the same nodes. This can be achieved by setting Retain View Link Accessor Rowset option for View Object tuning.
    Download - RetainViewLinkAccessorApp.zip

No comments: