Skip to Content
0
Former Member
May 18, 2010 at 09:21 PM

posting journals very slow

96 Views

Hi,

when we post a simple journal it takes a long time before the journal has been posted (30 sec - 1 minute):

- we have no journal scripting behind it

- we perform lite optimizes which reduces the throughput time, but the minimum remains on 30 secs for one simple journal.

When performing a trace in BW we notice the system often reads on the facttable of the cube joined with all dimension member tables. This query is executed > 10 times ... and takes up to 0,5 -1 second in average ...

Is 30 seconds normal behaviour. We really think this is very slow ...

regards

Dries