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 req...
Advanced ADF and Webcenter Learning