[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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