tm1s.exe - load time

[yyi]

server boot sequence begin fast then once the commit charge reach a few hundred mbs, the rest of the cubes seem to load about 10k p/hr . does anyone have any tune up tips like multi thread load, mem tweaks or cube/feeder arrangements
spec = win2003svr, 9.1sp3 x86, 8Gbs.

[Eric]

What is your total load time?

[yyi]

total is about 12mins, what i don't understand is why the brakes go on after the first 3 seconds when it's already loaded most of the cubes in memory

[Eric]

12 minutes is not bad. I know someone who has a load time of 6 hours!

potential culprit to load time after data load.

1) Feeders
2) Security

[ScottW]

Yeon,

If you look in the tm1server.log then you can see exactly what is taking the time.

TM1 server loads in the order:
- dimensions + element attribute cubes
- data cubes + process feeders (per cube with feeders in the rule file)

Loading data is extremely fast. The thing that takes the time is processing feeders of large cubes. It's not uncommon for the majority of server load time to be processing feeders for one or two cubes.

12 minutes is a small tm1 model by any stretch, I wouldn't be too concerned either way.

[David Usherwood]

You can multithread feeder loading by setting
MaximumCubeLoadThreads = <x>
in TM1S.CFG
where x should be 1 less than than the cores on your server. This works on 8.4.5 (very well) 9.1 (pretty badly) and in initial testing, 9.4 (rather well). But not on 9.0SP<anything>.

[Eric]

Didn't know about that, must be because I'm on 9.0