I'm curently trying to improve the performance of a multi tenancy database application.
There are multiple web servers and database servers for load balancing. The application is accessed via internet. Some of the components are in COM+.
The application architecture is N-tier.
When running the application I noticed lots of queries to the database. Investigating this I found the middle tier sent lots of individual queries to the database and some of these were in loops.
We assumed the performance issues are related to too many round trips to the database so we have removed the queries from loops and batched up most of the queries to send to the database in one query.
I have two questions;
1. How can we estimate the cost of a round trip to the database given that we have ...
Go to the complete details ...