Sunday, January 9, 2011

JDev/ADF sample - ADF 11g Performance Tuning - Select One Choice and Combo Box with List of Values

  • ADF 11g Performance Tuning - Select One Choice and Combo Box with List of Values. Blog reader was asking why ADF 11g page load time is slow, in case when page contains multiple heavy Select One Choice components. See comments for this post - Oracle ADF 11g Release 1 - Runtime Page Load Performance Improved !. Also, it seems like people are mixing two things together - Select One Choice and List of Values (LOV). Before JDeveloper 11g R1 (before Fusion Middleware was released), we were experiencing such issue, when List of Values query was executed, immediately on page load. Of course this was causing lots of delays, imagine to execute 20 additional SQL queries for 20 List of Values components available on the page. However, since JDeveloper 11g R1 this issue was fixed and List of Values queries are not executed anymore on page load, only on demand - when user opens LOV component. With Select One Choice is another story, this component must be populated on page load, it will execute database query to bring list data. This means for better page load time, you should use Select One Choice only for those attributes, where returned list contains only few rows. At the end, there is no point to have long Select One Choice list, it will be unusable anyway.
    Download - ChoiceListLOVPerformance.zip

No comments: