Kbase P109016: ProDataSet with non-unique parent/child relationship loads slowly when using the FILL method
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/09/2005 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
The FILL method of a ProDataSet is slow
ProDataSet has multiple parent/child relationships where parent records are not unique
Manually loading the ProDataSets temp-tables via a FOR EACH is much faster
CAUSE:
When a ProDataSet has a parent/child relationship where the parent records are not unique the FILL method will attempt to load child records for each parent record even when the child records already exist
FIX:
Manually load the temp-tables within the ProDataSet instead of using the FILL method