Improving Report Computation speed

Doesn anyone know how to read input from a flat file. I know that this will require scripting.

What I want to do is have a simple file that contains part numbers:

part1
part2
part3
Date: Tue, 11 Dec 2001 14:32:39 -0500 (EST) From: list-archives@listserv.aol.com
Status:

=========================================================================
Date: Wed, 22 Jul 1998 11:24:10 +0200

Vinnola, David schrieb:

Does anyone have any experience or information on improving report computation time?. Maybe what one factor kills performance. I am sure many factors affect report computation speed: 1. # of rows in the query(s)
2. # of variables in the report
3. # of variables built on variables
4. Multiple queries being “linked” into a single report 5. One query with multiple selects being “joined” by Business Objects 6. Client configuration
7. Report type (Master/Detail - one block vs. tabular, etc…) 8. Ability to “undo”
9. ???

One of the above definitely does not influence the computation speed: No 5 only contributes to the time for creating the (internal) microcube. This is done at every “refresh”, but NOT on subsequent generations (open/restructure, etc) of the report.

#of “derived” variables (from my experience) heavily influences the computation behaviour. Try to avoid it by using “more specific” if-then-else constructs…

In general: the more variables/functions you have locally the less performance…

Hope this helps…
Walter

DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at


Listserv Archives (BOB member since 2002-06-25)