RAM Speeds

Post Reply
User avatar
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

Post by Steve Rowe »

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?
Technical Director
www.infocat.co.uk
User avatar
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

Post by tiagoblauth »

No, but I can help on TM1 parallel processing using TurboIntegrator if that is your problem.
User avatar
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

Post by qml »

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
User avatar
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

Post by jim wood »

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

Post by Steve Rowe »

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....
Technical Director
www.infocat.co.uk
Post Reply