| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Performance problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| chanduy9 |
 Posted: Mon Jul 01, 2002 2:44 pm Post subject: Performance problem |
 |
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
I am using a flat file of size 8928kb, i am trying to convert from mrm to xml..i am not using any data base nodes. I am using only set outputroot.xml....in while loop. It is taking 1hr to process this message. can we do any performance tuning at broker level to process the message fast. In general what are all steps we have to take for performace issues.
Thanks in advance.
Chandra. |
|
| Back to top |
|
 |
| kirani |
| Posted: Mon Jul 01, 2002 5:14 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Chandra,
By any chance do you have Trace enabled on your MessageFlow/ExecutionGroup? I suspect your message flow is looping somewhere. It shouldn't take this long to process single messages. could you explain more about your message flow processing and your current environment/configuration settings? How much was the CPU consumption when you were processing this message?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| chanduy9 |
| Posted: Mon Jul 01, 2002 5:25 pm Post subject: Performance problem |
|
|
Disciple
Joined: 28 Nov 2001
Posts: 177
Location: USA
|
Hi,
I am executing on my local machine(WIN2000)....which is having 512MB RAM..when i ran this test CPU utilization is 100%. I got same problem on AIX also. I am not running any trace commands. The same flow is working fine for small size files.
Thanks in advance...
Chandra. |
|
| Back to top |
|
|
| kirani |
| Posted: Mon Jul 01, 2002 5:33 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
How much time does it take for processing small message?
Is it possible to post the contents of the compute node where you do the transformation and a sample input message?
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| mpuetz |
| Posted: Fri Jul 05, 2002 2:41 pm Post subject: |
|
|
Centurion
Joined: 05 Jul 2001
Posts: 149
Location: IBM/Central WebSphere Services
|
Hi,
without the source code of your mapping I can only be very general
about performance tuning, but here are some hints:
1.) Precalculate CARDINALITIES and store them in INTEGER vars.
2.) Use the new REFERENCE variables where possible
3.) Try to reformulate your SET-type mappings as complex SELECTS
I recently tuned a very simple WHILE LOOP of the type
WHILE i <= CARDINALITY(InputBody.Msg.Array[]) DO
SET OutputRoot.abc.xyz.def[i].x = InputbBody.Msg.Array[i].value_x;
SET OutputRoot.abc.xyz.def[i].y = InputbBody.Msg.Array[i].value_y;
SET i = i + 1;
END WHILE;
where CARDINALITY(ARRAY) > 5000
by a factor of 20 by do this
SET c = CARDINALITY(...)
WHILE i <= c DO
and another factor of two by doing this
DECLATE src REFERENCE TO InputBody.Msg.Array[1];
WHILE LASTMOVE(src) DO
SET OutputRoot.abc.xyz.def[i] = ROW(
src.value_x AS x,
src.value_y AS y
);
MOVE src TO NEXTSIBLING;
END WHILE;
and another factor of 1.5 by using a select
SET OutputRoot.abc.xyz.def[] = (
SELECT
A.value_x AS x,
A.value_y AS y
FROM InputBody.Msg.Array[] AS A
);
I hope this will give you some ideas.
_________________
Mathias Puetz
IBM/Central WebSphere Services
WebSphere Business Integration Specialist |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
