Kbase P116987: Performance slower on Progress Workgroup Database when migrating from HP 11.00 to HP 11.11 ( 11i ).
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/1/2010 |
|
Status: Verified
SYMPTOM(s):
Performance slower on Progress Workgroup Database when migrating from HP 11.00 to HP 11.11 ( 11i ).
Batch jobs which read a large number of records taking longer to run after migrating from HP 11.00 to HP 11.11 ( 11i ) with Progress Workgroup Database
FACT(s) (Environment):
HP-UX 11i
HP-UX 11i
Progress/OpenEdge Product Family
CAUSE:
HP has acknowledged that a modification was made to a function Progress uses frequently within its code.
HP modified the poll system call in 11.11 ( aka 11i ) to maintain compliancy with some published Unix standards. The original behavior in 11.00 was that when request to wake a process up at 10ms poll would actually wake processes up at 9.5ms which is a violation of Unix standards.
Now in 11.11 poll will never wake up a process earlier than the requested time. However the side effect of this change is that processes may be woken up significantly after the requested time.
By observation of an actual application the same poll call set for a 10ms wakeup would occasionally wake up a process at 20ms or 30ms and rarely ever wake up the process at the requested 10ms.
HP is aware of this issue.
FIX:
One solution is to revert back to HP 11.00 (although this is not the preferred long term solution by Progress or HP) it may be necessary to restore reasonable performance as a short term solution.
Another solution might be to upgrade to Progress Enterprise Database license which using a different algorithm than the poll method for some of its internal scheduling.