05102 - DIA vs BTC Performance

05102 - DIA vs BTC Performance

BAL_S_LOG - Application Log: Log header data   ABAP Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

DIA vs BTC Performance

According to your stats this is my observance.....

The first time after building an index and running a program it will always run
the longest due to building access path / SQL package / buffers (see Run 2 below
- 10 minutes)

Run 3 - 10 seconds in BTC should have nothing to do with BTC vs. DIA - Did you
try to run it again in DIA? If yes, you should have seen a 10 second response
time; since sql packages and access paths were built from

Run 4 - 10 seconds (after bringing down SAP)

Run 3 & 4 were both consistently 10 seconds

You always want to run a program at least 2x after building an index before you
can determine/observe its "true runtime"

Run 1 - 30 minutes arrival sequence
Build Index
Run 2 - 10 minutes in DIA
Run 3 - 10 seconds in BTC
? Why faster in BTC?
Bring down SAP
Run 4 - 10 seconds in DIA
? Why faster after bring down SAP

Doreen Anderson
Ball Horticultural Company
(630) 231-3600 x3214

-----Original Message-----
From: kiamlian [mailto:kiamlianZp...]
Sent: Sunday, February 17, 2002 8:19 PM
Subject: Re: DIA vs BTC Performance

Hi, after bringing down R3 on Sunday, the report now takes only
about 10s to run.

Does this mean I can expect the run time to increase over time?


--- In SAP on System iZy..., "kiamlian" <kiamlianZp...> wrote:
> Hi, I have a report that ran for almost 30 minutes. Did a trace and
> found that it is using arrival sequence on GLPCA (which is growing
> about 140000 rows a day). Thus, I created an index for the table.
> After sending it to production, the report ran for less than 10
> minutes. By right, I should be happier. However, when I send the
> report to run in Background, the report took only about 10 seconds
> complete!
> Anybody has any idea why? TIA.
> akl.

Have a look to our homepage at:

Your use of consolut is subject to

Durban Tours - Südafrika Safari

PERFORM Short Reference   BAL Application Log Documentation  
This documentation is copyright by SAP AG.

Length: 3200 Date: 20240304 Time: 185207     sap01-206 ( 3 ms )