ADF: Simple steps create a Shared Application Module instance to improve performance

 Below steps show how to create define a Application Module instance and share it across application.

      1.       Build ADF BC for HR tables Employees, Departments. Create two application Modules EmployeeAM and CommonAM.

        2.       Add Departments View Object instance in CommonAM Data Model.

         3.       Add Employees View Object instance in EmployeeAM Data Model.

        4.       Go to Model project properties -> Business Components -> Application Module instances. Here you’ll see option to add an Application Module instance as shared across Application or Session.

       5.       Now you’ll be able to see the Shared Application Module Instance when declaring view accessors for a view object.

      6.       If you create two different connection pools for each AM, and assign them accordingly in AM configurations.

      7.       Open two separate page in two different browsers you can observe that the Shared Application Module uses a single database connection.

 You can download the complete application here.

      8.       Using this option provides following performance benefits

·         Improved runtime performance.

·         Numbers of queries executed against database are reduced.

·         Memory utilization for storing view object rows is reduced.