Friday, July 3, 2009

Oracle ADF 11g Release 1 - Runtime Page Load Performance Improved !

Since yesterday, when Oracle Fusion Middleware 11g became available, I have done quite extensive testing on previously known ADF problematic areas.

Cool thing is that page load time even for complex pages is much faster now on runtime. Its because previously on page load, SQL queries for all available LOV components were sent to database. So, if page contains 20 LOV components, means 20 SQL statements were sent to database, it was killing performance especially when working on larger datasets. Now its fixed, and on page load SQL queries for LOV components are not pre-executed anymore - only main SQL statement is executed. Means - page load performance improved significantly.

In my next post I will describe how to tune your ADF application design in order to get high performance in CRUD applications.
at

5 comments:

  1. AnonymousJanuary 5, 2011 at 7:45 PM

    Hello,

    We are using Jdev 11.1.1.3.

    In ADF application jsff page, we have 10 LOV fields in the page, each having more than 8000 values. The page is extremly slow while loading it. When we remove all the SelectOneChoice and run the page, it is lighting fast.

    But in your blog post, you had mentioned that 11g is not executing the LOV queries on page load.

    Is there any configuration that we need to do in Application that we will fetch the LOV values on demand, so that the page load is faster?

    Thanks
    Manasa.

    ReplyDelete
  2. Andrej BaranovskijJanuary 6, 2011 at 2:45 PM

    Are you using "Choice List" or "Input Text with List of Values"?

    Andrejus

    ReplyDelete
  3. AnonymousFebruary 3, 2015 at 10:43 AM

    Hi Andrejus,

    Pls explain the case difference while using the Choice List" and "Input Text with List of Values" w.r.t performance. I am also facing the same performance issue.

    ReplyDelete
  4. Andrej BaranovskijFebruary 3, 2015 at 10:54 AM

    This is simple:

    - Choice List - data is fetch on page load
    - LOV - data is fetched only when user opens actual LOV popup

    Andrejus

    ReplyDelete
  5. AnonymousJanuary 4, 2017 at 10:02 AM

    Hi Andrews,

    I am loading a page which has 4 LOV attributes. These 4 LOV attributes are having Query Criteria and Display criteria. Query Automatically mode is also disabled for the view criterias.
    I am facing an issue like, blind query is executed for for all the 4 LOVs on Page load.
    In jsff Page, I have mapped LOVs for inputComboboxListOfValues.

    Kibdly help. Why the blind queries are executed for the LOVs on Page Load?

    ReplyDelete