Kbase P148759: Query takes significantly longer on Webspeed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/28/2010 |
|
Status: Verified
SYMPTOM(s):
Query takes significantly longer on Webspeed
Code takes longer to execute on Webspeed than from the Procedure Editor
Performance problem running database triggers on WebSpeed
FACT(s) (Environment):
WebSpeed Application
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
An inefficient query was being executed on the WebSpeed agent because of some specific application logic that was executed in a write trigger.
FIX:
Use the Application Profiler or some other tracing tool to locate the bottleneck in the code.