Performance Questions and a little need for some education.

[Ken Langendock]

IMHO = In My Humble Opinion

 

In my opinion the benefits of coding, debugging and maintaining source code,
make QTP the better choice for extracts.

 

In the past I let my Abnormally skilled Users (ABUSERS) create reports with
only QUIZ. I would then take their reports and convert them to QTP. To me
QUIZ is an end-user tool or a simple report writer and will always be. 

 

I have seen unskilled QTP go from 2 hours to 20 minutes with OUTPUT PHASE
READS and then down to 2 minutes with CURSORS. The results were staggering.

 

Unfortunately I cannot help you with the Titanium version. I create programs
on the slowest machine in an environment (as a rule) and deploy to the
fastest. That way if it performs ok on my development machine, it flies on
the production machine. I always develop in QTP first (Even Quick-in-batch
when I want to do a "perform-until" scenario) before I ever touch quiz.

 

Ken

 

From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of John Stires
Sent: August 18, 2009 10:59 AM
To: powerh-l at lists.sowder.com
Subject: [Bulk] Performance Questions and a little need for some education.

 

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/9c635556/attachment.htm