ServiceCenter bulkloads gradually slows down using WebServices

[mlazenby]

We have a problem with bulk loading a lot of locations data from HPSC to an external database using WebServices. It starts off fast initially, but then slows down gradually until it stops:

1.A scheduler calls a ScriptLibrary record called “GEN_mcc_bulkload”,
2.This queries the location table and stores the records that need to be sent from SC,
3.Then the function loops through the records and determine if the record needs to be created or updated on the external db,
4.Another function then takes a record, enrich it with more field values, builds it with a header and so forth and sends it to the “CustomAccountWebMethods” ScriptLibrary (invoke function) which is the converted wsdl file into JS.
5.Within the “invoke” function the soapHeader, soapBody and soapEnvelope get set. (NO TIME/MEMORY PROBLEMS YET).
6.Then the “lib.SOAP.serialize” scriptLibrary gets called. This is an OoTB ScriptLibrary on HPSC6.1.4
7.In this “serialize” function, in the SOAP ScriptLibrary, I have put some more print statements and found that it takes longer and longer gradually to go through this function.
8.I am not exactly sure how this function works, and want to know if anyone has had simmilar experiences using Webservices.

I think somewhere, some variable builds up or uses system memory and doesn’t get cleared properly.

Any help would be appreciated.

[leonv]

The serialize functions basically builds up the xml for the webservice call. So it would take your field values and put them in the correct format, eg:
<instance>
<Location>MyLocation</Location>
<City>MyCity</City>
</instance>

You should be able to manually build this up in javascript and bypass the serialization function, which may remove the slowdown in that function.

[mlazenby]

Thanks Leon, will give it a go.