Kbase P106873: SDO shows poor performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/9/2005 |
|
Status: Unverified
SYMPTOM(s):
SDO shows poor performance
RowsToBatch is very small (less than 5)
Performance gets worse closer to the end of the query
Client/server
CAUSE:
At the development level, there are a number of things that can cause this:
- The 4GL query used in the SDO can be inefficient
- The SDO's properties may not be properly tuned for the task
- The SDO may have inefficient code to handle calculated fields and similar tasks
FIX:
Check if the query is efficient by running it from a simple 4GL procedure outside of the SDO and tune it as appropriate.
Review the SDO instance properties:
- Use RebuildOnReposition wherever possible
- Determine the right value for rowsToBatch; smaller is not always better since more batches will need to be fetched, which carries a larger total overhead.
Review custom code in the SDO to see if performance can be improved there.