Hi,
I am trying to extract an XML field from external database.
And the extraction step takes around 1.5 hours to extract around >1,580,000 rows and one column which has data in XML format.
We need only one tag's value from the XML field.
How can the reload time be reduced?
And how can we extract only the field that we are interested in (enQty tag in the below XML)?
The content of the XML field is below :
//<postVEE>
//<dvcIdN>747237099405</dvcIdN>
//<mcm>1.000000</mcm>
//<tz>GMT</tz>
//<stDt>2014-08-01-00.00.00</stDt>
//<stQty>23.485</stQty>
//<enDt>2014-09-01-00.00.00</enDt>
//<enQty>37.512</enQty> -- VALUE TO READ
//<ccond>501000</ccond>
//<sts/>
//<msrs>
//<mL>
//<s>1</s>
//<dt>2014-09-01-00.00.00</dt>
//<q>14.027</q>
//<fc>501000</fc>
//<sts/>
//</mL>
//</msrs>
//<cmwprn>2284182</cmwprn>
//<cmmiu_serial>04384341</cmmiu_serial>
//<cmmeterserial>H14AU213541</cmmeterserial>
//<cmspecial_read_flag>N</cmspecial_read_flag>
//<cmfield_investigation_flag>N</cmfield_investigation_flag>
//<cmfa_cancel_flag>N</cmfa_cancel_flag>
//<cmunit_of_measure>m3</cmunit_of_measure>
//<cmreading_datetime>2014-09-01T01:00:00.000+01:00</cmreading_datetime>
//<cmmeter_reading>37.512</cmmeter_reading>
//<cmmeter_multiplier>8.3</cmmeter_multiplier>
//<cmmeasurment_condition>D1RG</cmmeasurment_condition>
//<cmfa_remarks>Successful</cmfa_remarks>
//</postVEE>
