Kbase P108634: 4GL client performance is poor when a SQL-92 client runs a report.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/04/2009 |
|
Status: Verified
SYMPTOM(s):
4GL client performance is poor when a SQL-92 client runs a report.
SQL client session is not using READ_UNCOMMITTED isolation level.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.1x
OpenEdge 10.x
CAUSE:
SQL client is locking many records causing 4GL clients to wait for records.
FIX:
Change SQL-92 client's isolation level to READ_UNCOMMITTED.