Application Performance Issue

Question

If You have deployed your application. After some time client raising the performance issue. What will be Your Steps to resolve performance issue.

Jignesh Kumar · Answer

Hello, We need to perform few steps to optimize your code and application performance, Collect Information collect all information about application module or page which is taking more time Reproduce the Issue : Try to reproduce issue where it is taking time. Use Profiling Tools use profiling tools to identify rootcause for slowness Analyze Profiler Results Analyze profiler results which will help to find actual rootcause Identify Root Cause based on above steps we need to identify rootcause of slowness then need to take appropriate step to solve it. ?????? Optimize Code and Queries try to optimize code and queries whic are taking more time in page. Implement Caching If possible we can implement caching which will help us to improve response time while response from cache rather then database query. Database Optimization need to check on database side as well if possible we can check on table index, store producedure, functions etc. Parallelism and Asynchronous Processing if possible we can implement parallelism and asynchronous call to display results in page without blocking user page. 10. Filter Data Early If possbile we can implement filter server side Using WHERE clauses to filter rows as early as possible in the query execution process. 11. Optimize Joins Avoid unnecessary joins and limit the number of joined tables. Consider using EXISTS, IN, or JOIN instead of subqueries for improved performance.