Kbase P178928: WRITE-XML takes a very long time to write a DataSet to a LONGCHAR
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2010 |
|
Status: Unverified
SYMPTOM(s):
WRITE-XML takes 200 times longer to write a DataSet to a LONGCHAR variable than it takes to write each of the temp-tables in the DataSet to a LONGCHAR variable
The DataSet has eleven temp-tables defined for it
Every temp-table uses the NESTED option
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
When using the NESTED option what you are telling WRITE-XML to do is for each record in a parent table it must create a query for the child tables (all the way down the nested structure) in order to build the proper XML file. This can VERY easily cause WRITE-XML to have to generate hundreds, to thousands, to millions of dynamic queries. This is what causes the slow performance.
FIX:
Remove the NESTED option (unless it is absolutely required)