Initial Tuning and Design Considerations

Database performance is an important factor in an application’s
performance. As the application and its associated data changes over
time, the database has to be constantly tuned to perform at its optimal
level. However, efforts spent on tuning should be kept within a
reasonable limit; there is a point where additional tuning efforts will
only produce negligible effects. If the application performance is
still not satisfactory, then other changes should be considered, such
as moving the application to a faster platform.