Interstage Shunsaku Data Manager Operator's Guide - Microsoft(R) Windows(R) 2000/ Microsoft(R) Windows Server(TM) 2003 - - UNIX -

D.6 Estimating Resources Used by the XML Conversion Function

This section describes how to estimate the resources required when the XML conversion function is used.
Use the following formula to estimate the size of the XML document output when one record of a results table is converted to one XML document that has no tag layer or attributes:

[Table: Estimation Formula]

Definition unit	Variable factors	Size (bytes)
The XML document that is output	Number of bytes per column Number of columns per record Number of records Number of bytes in tag name XML declaration	number-of-records x ( XML-declaration + ( number-of-columns-per-record + 1 ) x ( number-of-bytes-per-column + 2 x number-of-bytes-in-tag-name + 5 ) )

Example Calculation

An example calculation of an estimate for the size of the XML document that is output is shown below.

If the variable factors are:

• Number of bytes per column: 30 (bytes)
• Number of columns per record: 20(columns)
• Number of records: 1,000 (records)
• Number of bytes in tag name: 20 (bytes)
• XML declaration: 21 (bytes)

The size of the XML document that is output

1,000 x (21 + (20 + 1) x (30 + 2 x 20 + 5)) = 1,596,000 bytes (about 1.6 megabytes)