Showing results for 
Search instead for 
Did you mean: 

Slow in Reading XML response

Former Member
0 Kudos

Hello Guys,

I'm trying to upload from the Itemlist of SAP to MSDE and DBF tables, but it takes 10 hours to upload 29000 records of Items. I'm reading in the XML file i got from the SOAP response. Is there anyway that I can fasten the process?

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Gilbert,

Extracting the data from the XML is apparently not a way to be preferred when handling a larger number of records. At least performance might become an issue - as you already found out.

You might consider to use ODBC directly (or maybe even DI APIs Recordset object) to get the data <b>or</b> export the data into a text file - depending on which data you want to export exactly (everything, a subset or a few) one or the other method might suit better. (You don't give to much information about the requirements )

The only alternative I can think of is hardware upgrade...



Answers (0)