How to optimize Database Calls to improve performance of an application
843859Jan 6 2010 — edited Jan 13 2010Hi,
I have a performance issue with my applications. It takes a lot of time to load, as it is making several calls to the database. And, moreover, the resultset has more than 2000 records that are returned. I need to know what is the better way to improve the performance
1. What is the solution to optimize the database calls so that I can improve the performance of my application and also improve on the trun around time to load the web pages.
2. Stored procedures are a good way to get the data from the result set iteratively. How can I implement this solution in Java?
This is very important, and any help is greatly appreciated.
Thanks in Advance,
Sailatha