RE: [sqr-users] SQR report performance

[Peter Burton <Peter_Burton@Hyperion.com>]

Nicholas,

With that version of SQR I would avoid using LET commands which are doing
the same thing as the primitive commands: ADD, SUBTRACT, MULTIPLY, DIVIDE,
MOVE.  The primitive commands are significantly faster.  LET might look
prettier but there is significant overhead with that functionality.

Peter

> -----Original Message-----
> From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
> [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org]
> On Behalf
> Of Chu, Nicholas
> Sent: Wednesday, August 04, 2004 4: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
> 
> 


************************************************************************

If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. 

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses.  The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com

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