There are multiple tweaks if performed on data access and data layer,significant improvement would be visible in the application. List of some such tweaks is as mentioned below -
Tuning Data Layer
Tuning dataaccess Layer
Tuning Data Layer
- Use materialized view, (if suitable) in place of very time consuming queries or views
- Use query re-write
- Use parallel execution of queries
- Use PARALLEL_DEGREE_LIMIT to control parallization on database level
- Partition big tables
- Choosing the right isolation level
- Use sql trace and explain plan both to analyze query for tuning
- Loading data very fast using partition exchange
- Types of index and correct one to choose from
Tuning dataaccess Layer
- Identify and resolve select n+1 problem in hibernate
- Use in clause in hibernate only if options inside in clause are few
- Avoid using explicit getSession in spring-orm
- Use jdbc batch while firing multiple query using jdbc
- Prefer batch operation in hibernate while executing multiple queries
- Prefer ordered collection over sorted collection in hibertnate
- Prefer parametrized SQL over completed sql created at run time
- For batch operations prefer 11g version driver for better performance
No comments:
Post a Comment