I am working on a project which is a large application in VB 6 & Oracle 8i. Application is using Oracle object library (8.0.5 OO4O). Customer wants to change the oracle client & OO4O from 8.0.5 to 9i or 10g. On doing this, the application performance drops to about 1/5 of original.
I want to know why the application is behaving this way and what kind of changes are required to be done to application code to regain the original performance.