old application has old hierarchy
new has new hieracrhy
The only difference between two application is 15 new stored base account member in account dimension.
there is a calc script which is attached.Normal run time is 40-50 minutes on old application.But on new application it is running for more than 2.5 hours.
i have set tried HOUR GLASS,HOURGLASS ON A STICK
sSET CALC HIGH
SET PARALLEL CALC 3 (ITS 32 BIT WINDOWS os)
SET LOCK HIGH
SET CACHE HIGH
Aggregate missing values is set to ON on the database but NOT within the script.
Fragementatio is completed before testing the calc script.
All the database and cache setting looks good.
No network issues.
seem none of the setting on th top is working.
Calc script is very simple.It may look very big but it chunked based on jan to dec i.e. total twelve parts.
You said this was a new application, does the old application get completely calculated or is intelligent calc (blocks already calculated are not recalculated) on?
The second, new application, may have to be calculated in full and then the next calculation will see the calculated blocks and ignore. can you post the entire calculation script or is this business rules/calc manager calcualtions?
did you compare the data and index cache settings on the new appliction with the old application?
Is there enough memory for both to be loaded on the server?
How big are the blocks in both applications ?
It's possible that those 15 extra accounts made the block size in the new application exceed a certain threshold that makes calculation take much longer.
That's the only difference I can think of if you have already made sure that everything else was the same in both applications.