V8 to V9 Performance Degradation?

[EweSaidIt]

We wish to upgrade our character-based application from v8.3D to v9.1D.
We connect primarily via shared memory on version 11.0 of HP-UX.

Initial application testing indicated a significant performance problem with v9.1D for block queries.

I then set up two small (100,000+ records) single-user databases using
default parameters, one v8.3D and the other v9.1D.
Typical results for a simple "for each" iteration across 10,000 records:
1.03 seconds on v8.3D
1.45 seconds on v9.1D

Meaning that v9.1D takes 40% longer than v8.3D, all else being equal! The relative performance degradation of "find first" is not as bad, but is still significant.
The relative performance degradation for v9.1D seems to be such that we
are reluctant to upgrade. PSC has been evasive on this issue. Can anyone else shed some light?

 

[Keith Owens]

I know this is an old post but we are experiencing similar performance degradation.


Can you give me some indication of how you solved your problem earlier this year.

We've tried PSC and scoured knowledge bases the world over and are still struggling to match the performance we had with V8

Any help or advice based on your migration would be great.

Many thanks

Keith
DBA Under Stress

 

[EweSaidIt]

We had some experts from Progress and Dan Foreman (tuning guru from Braveheart) out and they made some parameter tweaks. However basically we ended up compensating with a hardware upgrade, which I suspect is the normal solution to this issue.