MQSeries.net :: View topic

edasnarik · Posted: Thu Feb 18, 2010 1:00 am Post subject:

Hi Everyone,

Environment : 6.1

It is actually a WebService that is exposed and it interacts with databases.

Operations to be done by the node (either Database/Compute ):
Loop through the input (SOAP Message) cardinality structure and perform a lookup to the database and verify each of the field is present in database.
If it is not present ,throw an user defined exception.

We are thinking to implement a cache on this so we would be avoiding multiple calls to database. So there would be only one DB call unless the flow is restarted/ configuration changes are done.

Now considering the fact that we will be traversing a SOAP message intially , storing lots of required parameters(rows) in Environment , implementing Cache and having many a For loops on the Shared variables (obtained from db lookup) for linking them , which is preferable Compute or Database ?