RE: [sqr-users] SQR report performance

["Bryson, Steven" <Steve.Bryson@phh.com>]

Richard, you mention that use of arrays would help performance.  How is
their performance in comparison to temp tables or is there none?

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu]
Sent: Wednesday, August 04, 2004 4:39 PM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: RE: [sqr-users] SQR report performance



Report tuning is, in my experience, not that simple.  The SQL queries
themselves need to be well tuned.  The code needs to be efficient,
streamlined, well organized.  Don't do anything in a loop 100,000 times
that only needs to be done once.  That sort of thing.  There is no
substitute for review of the code by an experienced person.  Boilerplate
code by novice programmers can get the job done but can almost always be
improved. The judicious use of arrays can help big time.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Chu, Nicholas
Sent: Wednesday, August 04, 2004 3:10 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] SQR report performance

I was wondering if anybody can let me know what parameters in SQR can be
expanded to let it run faster?

We have SQR reports that is taking almost 20mins to run depending on the
size on the shipment.
We are accessing Oracle 9i using 

SQR V6.1.4 Copyright (C) Brio Technology 1994-2000.  All Worldwide
Rights
Reserved.

These are the only 3 that we've set:
SUBVARS=250
EXPRESSIONSPACE=2048
SQLSIZE=14096

I wonder what parameters and how much would take care of my problem.
Thanks!!

Nicholas

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


"The sender believes that this E-mail and any attachments were free of any
harmful and malicious code or defects when sent.  This message and its
attachments could have been infected during transmission.  By reading the
message and opening any attachments, the recipient accepts full
responsibility for taking protective and remedial action regarding the code
or such defects.  The sender is not liable for any loss or damage arising in
any way from this message or its attachments."

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users