MQSeries.net :: View topic - 5MB single message (multiple MRM recs) performance problem

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » 5MB single message (multiple MRM recs) performance problem

Goto page Previous 1, 2

5MB single message (multiple MRM recs) performance problem

« View previous topic :: View next topic »

Author

Message

Marek

Posted: Wed Jul 12, 2006 7:06 am Post subject:

Apprentice

Joined: 30 Jun 2004
Posts: 32
Location: Edinburgh

Ref.

jefflowrey wrote:

Can you adjust your Environment.Variables.SQL.Translation[] table so that you don't have to do the selects inside the loop?

That is, can you create a real index table so you can say something like

Code:

movementType = Environment.Variables.SQL.NewTranslation[i];

Or even use a reference pointer into that table.

I don't see how this will help. Variable movementType is set by looking down the Environment.Variables.SQL.Translation[] tree to find a match. I can't forecast where in the tree I'll get a match. Coding

Code:

movementType = Environment.Variables.SQL.NewTranslation[i]

would imply that I know the position. Perhaps I've misunderstood your intentions? Can't find anything in the Help about an 'index table'. Thanks again.

jefflowrey

Posted: Wed Jul 12, 2006 2:25 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

What I mean is write new code that will allow you to know where to find the movementType directly, without having to use a SELECT statement.

Build a new table, basically.
_________________
I am *not* the model of the modern major general.

shalabh1976

Posted: Wed Jul 12, 2006 10:47 pm Post subject:

Partisan

Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India

By running user trace can you tell me how much time the following line of code takes :

Code:

SET movementType = THE (SELECT ITEM T.TO_CODE
FROM Environment.Variables.SQL.Translation[] AS T
WHERE T.FROM_CODE = MyPointer.MOVEMENT_TYPE
AND T.TT_ID = 2);

_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate

Display posts from previous:

Goto page Previous 1, 2

Page 2 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » 5MB single message (multiple MRM recs) performance problem

Jump to:

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

Protected by Anti-Spam ACP