Originally posted by: BNP

I have a Map that has two input cards; the first are MQ messages (pulls in 330 every 4 minutes) the second is a Configuration file. Due to the size of the messages I have File specified, and since I want to have this map to run multi threaded I specify Unique for the WorkFilePrefix. The configuration file does not change so I wanted to specify REUSE, however due to the Unique specified on the WorkFilePrefix this causes the workfiles to regenerate every run. plus they are not deleted since reuse is specified. Does anyone know of a way to get REUSE to work on the one input file while still having the other running multi threaded. I am trying to increase my performance. And was thinking Reuse would be the way to do it.
Any help is appreciated.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: phil2030

There are limitations when it comes to running maps concurrently and if memory serves this is one of them... I looked at this several years ago when doing performance tuning and dismissed it due to it only being effective if you had a single stream of data and a very large "static" data structure - which I've never had.

How big is the configuration file? Have you analyzed how long it takes to parse?
How are you using the configuration file? Is it a complex structure? Are there multiple key fields or is there a simple primary key? Can't you put the data into a database?

Generally I would put any "lookup" data into a database and not use files at all.
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange