DTP First Package too slow

[Former Member]

I have a DTP which loads data from DSO to InfoCube. Total Records = 250,000 & Package Size = 25,000

Note - I tried various things by changing package size to 50,000 and 100,000.

8 out of 10 times I do not see any issues, but sometimes what happens is --> when the DTP transfers data from the DSO to the InfoCube, the first package runs for a long time (30 minutes) and the remaining packages take less than a minute to process the data. I was curious if anyone else encountered this issue with DTP's?

The problem is it happens only once in a while and only on the first package.

Issue - The performance of the DTP on the first package is too slow, but it works

Edited by: RK on Jan 21, 2010 12:48 AM

Edited by: RK on Jan 21, 2010 12:56 AM

[Former Member]

Hi,

I am experiencing the same issue.

Plz post any update if you have encounter or have a resolution for this issue...thanks

[Former Member]

I already checked what Sonni and Sven mentioned - but no luck yet.

RK.

[Former Member]

Hi,

Try running Delta DTP from Active Table only (without archive). This is a setting on the DTP.

Br,

Sonni

[Former Member]

Sonni,

I am currently using the same DTP setting which you mentioned.

RK.

[Former Member]

Hi RK,

check if there are any other jobs running in SM50 when it's running slowly.

Br,

Sonni

[sven_mader2]

or

delete the indizes of the infocube - the first time you can delete this.

Sven