Hello everyone,Perhaps someone can provide some direction for the problem that I face. We're building a standard web-based, 3-tier enterprise application using our own light-weight object-relational mapping layer.Serveral web pages have been identified for optimization in our system, as it has been shown that they recieve a lot of user traffic, and they all contain a fair number of complex gridviews. On each page-load, there is a lot of database contention as it pulls out the necessary data and builds the domain object graph. For example, a number of the gridviews display data from entities nested within other entities, which results in a lot of lazy-loading going on behind the scenes.I would like to optimize some of the grid views on these pages by constructing database views, which select only the necessary data columns that need to be displayed. I would then write entity/domain object classes for the view. These classes would be used primarily in displaying d ...
Go to the complete details ...