Hi,
Has anyone done any direct testing of RAM type / speed on the performance of TM1? DDR4-2933 is over twice as "fast" as DDR3-1333 for example. How does this translate into TM1 performance? Assume the motherboard etc changes as appropriate.
Any well informed views?
RAM Speeds
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
RAM Speeds
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- tiagoblauth
- Posts: 20
- Joined: Wed Jul 08, 2015 11:50 am
- OLAP Product: TM1, Cognos BI
- Version: 10.2.1
- Excel Version: 2010
Re: RAM Speeds
No, but I can help on TM1 parallel processing using TurboIntegrator if that is your problem.
- qml
- MVP
- Posts: 1094
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: RAM Speeds
Because as RAM clock speeds go up each operation takes more clock cycles, increasing the relative latency, therefore you cannot expect to double your performance. A more realistic outcome would be a 10-20% improvement, depending on many additional hardware and software factors.
Kamil Arendt
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: RAM Speeds
That depends on the CAS (timing) rating of the modules. Larger sizes (32GB) tend to have a worse CAS rating, so don't just look at the frequency, check the timing. Also ECC adds another factor. If you want large modules, with high speeds, low latency and ECC you're going to be spending some good hard cash. Oh and I've not even factored the channel support from the motherboard.qml wrote: ↑Tue Oct 15, 2019 10:27 am Because as RAM clock speeds go up each operation takes more clock cycles, increasing the relative latency, therefore you cannot expect to double your performance. A more realistic outcome would be a 10-20% improvement, depending on many additional hardware and software factors.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: RAM Speeds
Errr thanks....
So we could get 10%-20% improvement.
Jim, is your piece offering detail on Kamils "depending on many additional HW and SW factors" or are you putting doubt on the whole 10%-20%?
Hopefully we can at least say it won't be worse....
So we could get 10%-20% improvement.
Jim, is your piece offering detail on Kamils "depending on many additional HW and SW factors" or are you putting doubt on the whole 10%-20%?
Hopefully we can at least say it won't be worse....
Technical Director
www.infocat.co.uk
www.infocat.co.uk