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 less time.
5. Using the indexes carefully : Using indexes can improve the performance but if we do nat use them properly thy may result to erformance degradation.
6.Using WHERE clause instead of HAVING clause : usage of WHERE clause may take advantage of the index defined on the column(s) used in the WERE clause.
7. Using realistic test data : Use of realtime data always helps to identify and fix the isses.
8. Using EXPLAIN PLAN : It let you know the cost of your query line by line.So that you can identify or fix the issue at exact step or line. Press F10 in SqlDeveloper to get the cost of query.
9. Using the leading index columns in WHERE clause - the WHERE clause may use the complex index access path in case we specify the leading index columns of a complex index otherwise the WHERE clause won't use the indexed access path.
10. Using ORDER clause BY for an indexed scan.
11. Reducing network traffic - If we can club multiple SQL statements in a single PL/SQL block then the entire block can be sent to Oracle Server involving a single network communication, which will eventually improve performance by reducing the network traffic.
Arrays and PL/SQL blocks can be used effectively to reduce the network traffic.
12. Use of ROWID and ROWNUM : These special columns are used to ipmrove the performance. RowID search is the fastest for Oracle DB and this must be used wherever possible. RowNum is used where we want to strict the no of rows.
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 less time.
5. Using the indexes carefully : Using indexes can improve the performance but if we do nat use them properly thy may result to erformance degradation.
6.Using WHERE clause instead of HAVING clause : usage of WHERE clause may take advantage of the index defined on the column(s) used in the WERE clause.
7. Using realistic test data : Use of realtime data always helps to identify and fix the isses.
8. Using EXPLAIN PLAN : It let you know the cost of your query line by line.So that you can identify or fix the issue at exact step or line. Press F10 in SqlDeveloper to get the cost of query.
9. Using the leading index columns in WHERE clause - the WHERE clause may use the complex index access path in case we specify the leading index columns of a complex index otherwise the WHERE clause won't use the indexed access path.
10. Using ORDER clause BY for an indexed scan.
11. Reducing network traffic - If we can club multiple SQL statements in a single PL/SQL block then the entire block can be sent to Oracle Server involving a single network communication, which will eventually improve performance by reducing the network traffic.
Arrays and PL/SQL blocks can be used effectively to reduce the network traffic.
12. Use of ROWID and ROWNUM : These special columns are used to ipmrove the performance. RowID search is the fastest for Oracle DB and this must be used wherever possible. RowNum is used where we want to strict the no of rows.
Comments
Post a Comment