Kbase P13488: For Each query is running very slowly when connected via Cli
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/28/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1B
SYMPTOM(s):
FOR EACH query is running very slowly
On AppServer the same query runs fast
Client is connecting to the database via Client/Server
CAUSE:
The FOR EACH statement did not have any lock mode defined so Progress used the default lock mode (SHARE-LOCK)
FIX:
Add NO-LOCK to the FOR EACH statement