Kbase P120659: BUFFER-DELETE method performance is very slow
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/10/2009 |
|
Status: Unverified
SYMPTOM(s):
BUFFER-DELETE method performance is very slow
Deleting records with a dynamic query using the BUFFER-DELETE method, connected to a remote database server can be very slow.
Deletion using a FOR EACH EXCLUSIVE-LOCK can be done in several seconds,but using the BUFFER-DELETE method this can take several minutes.
FACT(s) (Environment):
OpenEdge 10.1A
All Supported Operating Systems
CAUSE:
This is a known issue being investigated by Development
FIX:
As a work around set the query object FORWARD-ONLY attribute to TRUE before opening the query. This significantly improves the performance of the BUFFER-DELETE.