Application Patterns causing poor performance

This series of blogs is a direct response from observing application patterns that can cause poor database performance. Some of the patterns are may seem trivial or simple, but they still need to be covered because we see them many times. Most of the patterns have a simple interpretation of what causes the bad performance – too many round trips to the database.

Here are the patterns that will be covered in future blogs:

1. Complex screens.

2. “Academically correct” object modeling
   
   
3. Row-at-a-time processing
   
   
4. Using middle tier application servers for batch jobs