Skip to main content

Posts

Showing posts from May, 2014

SQL Query Tuning

Follwoing points need to be taken care while developing the ADf application.With these points we can improve the application perforemance. 1. Understanding of the Data, Business, and Application : First and most importanat point is to understand the data model properly,in terms of table dependency.If we are clear about relationship between tables then it will be easy to write query and implement the logic by using various clauses,conditions,joins.. 2. Simple is usually faster   :  instead of writing a very complex SQL qeries, if we break it into multiple simple SQL statements then the chances are quite high that the performance will improve. Make use of the EXPLAIN PLAN to see the query cost.  3. Joining tables in the proper order : Use proper joins between the tables.An improper join can result into performance issues. 4. Using Bind Variables, Stored Procs, and Packages : use proper bind variables where possible in queries.It will fetch the required results only and take l

ADF LifeCycle

Intro : When a page is submitted and a new page requested, the application invokes both the ADF Faces page lifecycle, which extends the standard JSF request lifecycle, and the ADF page lifecycle. The extended JSF lifecycle handles submitting the values on the page, validating component values, navigating pages, displaying components on the resulting page, and saving and restoring state. The FacesServlet servlet manages the request processing lifecycle in JSF applications. It creates an object called FacesContext , which contains the information necessary for request processing, and invokes an object that executes the lifecycle. The ADF page lifecycle handles preparing and updating the data model , validating the data at the model layer, and executing methods on the business layer . It uses the binding container to make data available for easy referencing by the page during the current page request. With following example you will get the detailed idea about the ADF Lifecyle.