Informix DBA Survival Guide, Second Edition

Doing it Right the First Time

This chapter assumes the most common type of tuning environment, in which you're called in to tune up an existing system. You'll have some sorts of constraints placed upon your tuning activities depending upon your environment. If, by some freak of chance, you are tuning a production database before it actually goes production, you are in the rare position of being able to do it correctly the first time

If you can interject tuning issues early into the development process, you'll avoid many of the difficulties of tuning an active production system. The key to doing the development properly is to test at very high volumes and to resolve the tuning issues before the system goes into production. This is a lot more work ...