Re: [sqr-users] SQR report performance

[bknoch@hinda.com]

More information would probably help.  Is it a single sql statement taking
20 minutes, or several ones?  Perhaps one running in a fraction of a second
but with several hundred thousand iterations?  Is the report returning
massive amounts of data?

Are your indexes good?  Are the statistics updated on the tables?  Is the
optimizer choosing the right indexes?




|---------+-------------------------------------------->
|         |           "Chu, Nicholas"                  |
|         |           <Nicholas.Chu@RedPrairie.com>    |
|         |           Sent by:                         |
|         |           sqr-users-bounces+bknoch=hinda.co|
|         |           m@sqrug.org                      |
|         |                                            |
|         |                                            |
|         |           08/04/2004 03:09 PM              |
|         |           Please respond to "This list is  |
|         |           for discussion about the SQR     |
|         |           database reporting    language   |
|         |           from Hyperion Solutions."        |
|         |                                            |
|---------+-------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |       To:       "'sqr-users@sqrug.org'" <sqr-users@sqrug.org>               
                 |
  |       cc:                                                                   
                 |
  |       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



This communication is for the exclusive use of addressee and may contain
confidential, proprietary or privileged information which may be used
exclusively for its intended purpose. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited.  If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication, and
destroy all copies.


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