Object Relational Mapping

Optimizing Performance Of A Three Tier Application

by Verax Systems on Sep 23, 2009

It is common that more than one element of the system is changed or tuned during the optimization activities, but the decision which subsystems or layers to optimize should always be based on observations where the bottlenecks of the system are. The article lists and briefly describes a set of hints and good practices one should consider when attempting to deal with the challenging task of software optimization. Database Database optimization has always been a big topic. Slow data access is quite often a reason for poor application performance. The first thing one should always do when dealing with such a problem is to monitor the behavior of the system. This will almost always provide a good hint as to where the problem may be located. There are several most important aspects that are looked at when trying to squeeze more power out of the database: •   Schema optimization. It is worth analyzing whether it may payoff to do some database denormalization. Some parts...Read More >>