I am trying to do the following:
- query a customer erp system for item or customer master data
- loop through the results and build an xml document (just a long concatenated string)
- transmit resulting xml document to the target system
My problem is that I can’t make it perform. The sql query is fairly fast (maybe 1 minute), and the transmission is fast as well. However, the looping through and putting into an xml string is very slow. For about 40,000 records with about 24 elements each, it takes a little over 24 hours. I must be missing something. We are using IS 6.1 on a fast windows server (3GHz) with the maximum amount of memory. Any suggestions would be appreciated.