I've been through the app vs DB meat grinder several times.
My shop uses Informix. There is a wealth of tuning information available at the
International Informix Users Group. Membership is available at no charge, and gives access to a software repository that contains a lot of useful tools.
Dave
Code On!