What Things You Would Care About To Improve The Performance Of Applic – InterviewSolution

InterviewSolution

1.

What Things You Would Care About To Improve The Performance Of Application If Its Identified That Its Db Communication That Needs To Be Improved ?

Answer»

Query Optimization ( Query REWRITING , Prepared Statements )
Restructuring Indexes.
DB Caching TUNING ( if using ORM )
IDENTIFYING the problems ( if any ) with the ORM Strategy ( If using ORM )

Discussion

No Comment Found

Related InterviewSolutions

Shall We Use Abstract Classes Or Interfaces In Policy / Strategy Design Pattern ?
Difference Between Factory And Strategy Design Pattern ?
Difference Between Builder And Composite ?
Difference Between Adapter And Facade ?
Difference Between Proxy And Adapter Design Patterns ?
What Kind Of Software Architecture Your Organization Follow ?
How Do You Coordinate And Communicate With The Team Developers ?
Which Uml Diagrams You Usually Use For Design ?
What Would You Do If You Have To Add A Jar To The Project Using Maven ?
If You Are Given A Choice To Implement The Code To Either Insert A Record Or Update If Already Exist, Which Approach Will You Follow ? 1. Insert Into The Db Table. If Exception Occurs, Update The Existing Record. 2. Check If The Record Exists And Update It If It Exists, If Not Insert A New Record.