Joined: 18 Jul 2002 Posts: 381 Location: Gurgaon, India
I just did a performance test on a windows P4 machine using the two sets of statements in a large loop. From the usertrace I was able to get some numbers:
The Create statement is better than the SET .
I have no reasons for why it is so, but you wanted facts and here they are:
Time for the Create statements in a loop of 768 times = 0.344 sec
Time for the SET statements in a loop of 768 times = 0.3910014 sec
I am not sure if this was a correct way to check the performance nos but if someone has better ideas then please advise. _________________ Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate
Joined: 23 Sep 2003 Posts: 232 Location: IBM (Retired)
The reason Create is faster is due to the Reference Pointer - it keeps track of where you are in the messsage tree. A Set has to find the right location. The larger the tree, the larger the difference. I did some tests some time ago with a 64,000 element tree and had an even larger difference.
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