[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR report performance
- Subject: [sqr-users] SQR report performance
- From: "Chu, Nicholas" <Nicholas.Chu@RedPrairie.com>
- Date: Wed, 4 Aug 2004 15:09:43 -0500
- Delivery-date: Wed, 04 Aug 2004 15:11:47 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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