Kbase P24618: Poor performance retrieving data with Java
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/05/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Poor performance retrieving data with Java
CAUSE:
The 4GL code was using NO-LOCK when retrieving the records, however, the Java code was using the default transaction isolation level (repeatable read).
FIX:
Modify the Java code and change the transaction isolation level to 'read uncommitted'