Tasks
Application tuning
Tuning the app is the most important part of the tuning activities. While environment-related tuning is important to optimize resource use and avoid bottlenecks, it cannot compensate for a poorly written app. The majority of performance-related problems are related to app design and coding techniques. Only a well-designed app, implemented with the best practices for programming, will give we good throughput and response times.
Review the app code itself as part of the regular app life cycle to ensure that it is using the most efficient algorithms and the most current APIs that are available for external dependencies. Take care to use optimized database queries or prepared statements instead of dynamic SQL statements. An important task with which to optimize the app performance is app profiling.