Rules performance 10.1.1 vs. 9.5.2

holger_b · Post by **holger_b** » Fri Jun 07, 2013 12:41 pm

I inherited a model with a number of terrific rules which I dare not touch if I can avoid it. These days, the client moved the application to a new server and we took the opportunity to upgrade to 10.1.1. Unfortunately we see now that some Excel and TM1Web reports which used to be slow but more or less tolerable, take twice the time compared to 9.5.2.

Anything else is neat and quick as it should, just this one cube is a problem. Any ideas?

Regards
Holger

jim wood · Post by **jim wood** » Fri Jun 07, 2013 1:46 pm

Have you your setting in the CFG file? I would do this and look at some options for the CFG file in 10.1.1. This way hopefully you'll be able to see a difference without touching the rules,

Jim.

holger_b · Post by **holger_b** » Fri Jun 07, 2013 2:04 pm

Thank you Jim, but the tm1s.cfg is identical... Here is the contents - nothing special in it in other words...

ServerLogging=F
SecurityPackageName=Kerberos
IntegratedSecurityMode=1
ServerName=Contdata
DataBaseDirectory=d:\TM1Data\dbname
LoggingDirectory=d:\TM1Data\Logging
AdminHost=DEMUAPP40000
PortNumber=12346
Language=DEU
SaveTime=
DownTime=
GroupsCreationLimit=20
excelwebpublishenabled=false
IdleConnectionTimeOutSeconds=14400

declanr · Post by **declanr** » Fri Jun 07, 2013 2:11 pm

holger_b wrote:Thank you Jim, but the tm1s.cfg is identical... Here is the contents - nothing special in it in other words...

Although the contents that you can see may be identical, there will be different results. Such as Parallel Interaction for version 10 defaults to True if it isn't specified int he CFG file, this wasn't the case in version 9.5.2.

holger_b · Post by **holger_b** » Fri Jun 07, 2013 2:16 pm

Ah! Good to know. Are there more hidden secrets like this? Or how could I have known?

George Regateiro · Post by **George Regateiro** » Fri Jun 07, 2013 3:14 pm

This type of stuff is generally put out in the new features guide with every release. The specific one about parallel interaction is mentioned in the third link down in the doc.

http://pic.dhe.ibm.com/infocenter/ctm1/ ... ainer.html

PlanningDev · Post by **PlanningDev** » Sat Jun 08, 2013 1:50 pm

If it makes you feel any better we actually have seen performance improvements in the web between 9.5.2 and 10.1.1 FP1

holger_b · Post by **holger_b** » Tue Jun 11, 2013 7:09 am

So did I up to now, this is the first time I saw the reverse effect. I will send the model to the IBM support and let you know what they think.

TM1 Forum

Rules performance 10.1.1 vs. 9.5.2

Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2

Re: Rules performance 10.1.1 vs. 9.5.2