Posted: Thu Apr 06, 2006 11:01 pm Post subject: Message Flow performance problem
Apprentice
Joined: 06 Feb 2006 Posts: 26 Location: PARIS/NEW YORK
Hello
I have a main Message flow with 2 subflows:
1 archive subflow - inserts XML message into database (ARCHIVE table)
1 log subflow - logs status into database (STATUS table)
Each subflow, tested individually, has a good performance (ressource utilization and throughput rate).
Meanwhile the main flow is 8 times less performant than each subflow. Increasing copies of the message increses obviously throughput rate, but performance is relatively bad with respect to the 2 subflows.
It seems that cumulating the 2 insert into the main flow reduce the performance.
In the design of the flow we tried to use the key considerations from Tim Dunn's article (Design and Implementation Considerations ...).
I am looking for more design considerations according to my problem. Can anybody help me ?
Joined: 18 Jul 2002 Posts: 381 Location: Gurgaon, India
If you run a full debug trace you will get to know the bottlenecks in your performance. You can then try to fix those.
You can use the timestamps in each step to know how much time each step is taking. _________________ Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum