All, I'm looking for some advice on how to fix a performance issue we are having with our application. We are running into some problems with the sheer amount of database calls we need to perform as part of our business logic and I was looking for some thoughts on what would be a good path to start investigating on. I apologize for the length of the post.
Ã?Â
The background:
Ã?Â
We have an n-tier application consisting of a WinForms client communicating to a business layer that resides behind a web service on a web/application server/farm. This business layer communicates to a data access layer which then communicates to a SQL Server tier (using the MS Enterprise Library).
Ã?Â
To make this as generic as possible, we basically have a business object that consists of two identifying pieces of integer information: an ID and a Version field. These business objects are modified in the client and th ...
Go to the complete details ...