What things you would care about to improve the performance of Application if its identified that its DB communication that needs to be improved ?

Interview Questions and Answers

Q1. What things you would care about to improve the performance of Application if its identified that its DB communication that needs to be improved ?

Solution

Ans. 1. Query Optimization ( Query Rewriting , Prepared Statements )

2. Restructuring Indexes.

3. DB Caching Tuning ( if using ORM )

4. Identifying the problems ( if any ) with the ORM Strategy ( If using ORM )

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve java db database hibernate orm at&t overstock.com performance improvement architecture technical lead architect intermediate}

Related Questions

Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?

Difference between first level and second level cache in hibernate ?

What are the benefits of using Spring Framework ?

What are various types of Class loaders used by JVM ?

Difference between SAX and DOM Parser ?

What things should be kept in mind while creating your own exceptions in Java?

How to implement an immutable class ?

Difference between C++ and Java ?

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 ?

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.