Performance Questions and a little need for some education.

[John Stires]

Thanks for the input.  I may need just a little more to put my mind to rest on this, though,

I have run similar bench tests before and the results have always been consistent.  This is the first time I have seen them vary.  The only thing I see different in this case, is the Titanium machine and a little later version of PowerHouse.  I am wondering if there is some tuning that is done on the Titanium machine that is unique to cause this kind of results.  The other possible cause might be that COGNOS has refined QTP to manage its baggage much better than it used to do.  As it is, the results on the ALPHA  are consistent to what I have seen in the past.  It is just on the Titanium that I am seeing such a difference.

In this case the output file is just a simple subfile.  There are no SORTs, or PARMs.  The QUIZ has only GETSYSTEMVALs to make up for an extract request in the QTP used only to set 3 Global TEMPs and GETSYSEMVALs are  only evaluated once in QUIZ.

In the past, I have never seen QTP out-perform QUIZ for simply extracting data and dumping it to a subfile, especially where there is no totaling or summarizing going included.  In this case the data is getting dumped into a subfile which is then renamed after the extract is complete.

My understanding is that DEFINES are done in registers while TEMPs use memory, which easily explains why DEFINEs have to be reevaluated and TEMPs do not.  All things being equal, and no DEFINE cascading, DEFINES would be faster.  Register access much faster than general memory.  It is only when you have multiple references, the cascading, that DEFINEs that the "fast" DEFINEs have to reevaluate and slow performance.  Register values are only transient.

QTP, as you say is robust and carries a tremendous amount flexibility, but with that, come a lot of baggage that is loaded whether it is used or not.  Whereas QUIZ does not carry such a large amount of baggage and, generally gets through files pretty awful fast by comparison for simple extracts.

Let me show a little more of my lack of knowledge and ask what (IMHO) is?

Thanks,
John
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20090818/5bc9afb0/attachment.htm