WRITE-XML() - performance

[davidvilla]

Hi guys,
Are there any tips/tricks to minimize the time taken for the WRITE-XML function?

 

[RealHeavyDude]

The only thing that springs to my mind is to avoid the formatting as this adds (syntactically not necessary) white space that makes the XML document better readable for humans but also increases it's size.

Apart from that the usual suspects when it comes to i/o: Write the document to a fast device ...

Heavy Regards, RealHeavyDude.

 

[davidvilla]

Thanks. I linked all my temptables in the dataset using a unique index field and is now much faster.

 

[RealHeavyDude]

Just to be clear: That is performance on the ProDataSet itself - as a side effect many operations like WRITE-XML() will benefit from it. IMHO the same patterns that make a database design a good one are applicable for Temp-Tables too. Proper Indexing would be one of them.

Heavy Regards, RealHeavyDude.

 

[davidvilla]

yeah... that's right! Thanks.