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 ...