MQSeries.net :: View topic

pottas · Posted: Thu Jun 22, 2006 4:59 am Post subject:

Guys,
I need some assistance...
First of all here's my set-up:
WBI 6, Fixpack 1, Toolkit 6.0.0.1
Interim Fix 4

And here's my question:
I need some way to load a DB table in memory to use the records for as long as the execution group is running / the flow is deployed.

Here's the scenario - I have a list of values in a table that I use to get the value from an Input message of my flow. So, in my database, I have the following type of records in qa table:
InputRoot.XML.SalesOrder.OrderID;

...from a subflow, I select this value from the database and then wrap an EVAL around it to get the physical value from my Input message. These values are then packed into an MRM and put on a queue for query purposes.

But this is expensive, firstly because of the I/O every time, and secondly the EVAL that I use.
So, what I want to know, is there a way to cache database records when I deploy a flow?
I understand that this is more of a design issue, so if someone out there have some other suggestion how to handle this, please let me know.

pottas