Kbase P122644: SELF Service connection much slower reading records exclusively
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/03/2010 |
|
Status: Unverified
SYMPTOM(s):
SELF Service connection much slower reading records exclusively
SELF Service clients are slower than remote client server connections when reading records exclusively.
A big -L locking table value makes self service EXCLUSIVE-LOCK reads very slow.
NO-LOCK reads are unaffected.
A remote client server connection is much quicker reading records exclusively than a self service client.
FACT(s) (Environment):
OpenEdge 10.1A
CAUSE:
Bug# OE00147520
FIX:
There are two known ways to work around this problem:
1. Upgrade to OpenEdge 10.1B or later.
2. Use a client server connection where full table scan locking is required.