Trends for Processor speeds

Not related to a specific OLAP tool. (Includes forum policies and rules).

Trends for Processor speeds

Postby Steve Rowe » Mon Mar 30, 2009 12:45 pm

Just wanted to ask what peoples views were on Processor speeds.

It seems to me that the current trend for many processors running at 3GHz does not serve a product like TM1 well. The max speed of a processor seems to be stalled around the 3GHz mark and the hardware industry seems to be focussed on multiple processors in a box rather than the speed.

Obviously these type of servers have their place but I'd much rather have a twin 4GHz than 8 3GHz processors as I think (guess really) my user base would be better served by a server like this.

Anyone else have comments or views?

Cheers,
User avatar
Steve Rowe
Site Admin
 
Posts: 1169
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 9.0 9.1 9.5
Excel Version: Nearly all of them

Re: Trends for Processor speeds

Postby jim wood » Mon Mar 30, 2009 2:14 pm

I guess for TM1 you are right. (Based on the current architecture) May be instead of looking at the frozen speed of modern CPU's, IBM should instead work on changing how TM1 handles multiple threads. The CPU and software industry have been moving this way for some time. Come to think of it where is a version of TM1 that works on Linux? Many businesses are moving their servers over to the likes of Red Hat (Especially Solaris based companies).
Legal Advisory: These are my personal opions... My opinion is I'm right most of the time.
ACG TM1 / Essbase Consulting
Server(s): Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client(s): Windows XP.
User avatar
jim wood
Site Admin
 
Posts: 2020
Joined: Wed May 14, 2008 1:51 pm
Location: 1639 Route 10, Suite 107, Parsippany, NJ
OLAP Product: TM1
Version: TM1 9.5.2 EV 9.5.0
Excel Version: 2007

Re: Trends for Processor speeds

Postby Steve Vincent » Mon Mar 30, 2009 2:19 pm

I guess it comes down to the CPU architecture. There is a cracking article on wikipedia about CPUs (for uber-geeks only!) but the general issue seems to be greater clocks > greater heat. From 3GHz onwards you are looking at serious cooling solutions and in a server room where rack space is limited i guess that starts to be a factor in CPU choice. Its generally a better solution for most programmes / systems to go multi-threading rather than push the cycles as that reaps better rewards compared to the issues with greater clocks. Its just the way TM1 works, it cannot utilise the architecture as efficiently so it benefits less.

Victim of its own success maybe? :|
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 9.5.2, Windows 2008 Server. Excel 2010, IE8 for t'internet
User avatar
Steve Vincent
Site Admin
 
Posts: 945
Joined: Mon May 12, 2008 8:33 am
Location: UK
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Trends for Processor speeds

Postby jim wood » Mon Mar 30, 2009 2:25 pm

From what I rember it's top do with the number of silicon wafers on one die. The more you have, the more it heats up. As for TM1, as I said above it needs to handle multi-thrweading better. Sitting there watching task manager use all of one cpu while the others are idle can be most distressing. They have managed to solve locking, why not multi-threading next?
Legal Advisory: These are my personal opions... My opinion is I'm right most of the time.
ACG TM1 / Essbase Consulting
Server(s): Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client(s): Windows XP.
User avatar
jim wood
Site Admin
 
Posts: 2020
Joined: Wed May 14, 2008 1:51 pm
Location: 1639 Route 10, Suite 107, Parsippany, NJ
OLAP Product: TM1
Version: TM1 9.5.2 EV 9.5.0
Excel Version: 2007

Re: Trends for Processor speeds

Postby Steve Vincent » Mon Mar 30, 2009 4:25 pm

this could get horribly technical, but i can see why they haven't ;)

threading is most useful when you have multiple tasks to do that are independant of each other. Unless you have a TM1 model where no cubes have rules or TIs that make them reliant upon each other, or share the same dimensions, i can't see how they can make proper use of threading. It would have to try and calculate 2 cubes until it found a dependancy on something then wait before continuing. How the blazes could they work that out when they can't write automatic feeders?! :lol:
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: TM1 64 bit 9.5.2, Windows 2008 Server. Excel 2010, IE8 for t'internet
User avatar
Steve Vincent
Site Admin
 
Posts: 945
Joined: Mon May 12, 2008 8:33 am
Location: UK
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2010

Re: Trends for Processor speeds

Postby jim wood » Tue Mar 31, 2009 7:02 am

Good point. They may have to sort both problems if they are going to utilise the product as they (IBM) have in mind. Here's to holding my breathe. (Not really)
Legal Advisory: These are my personal opions... My opinion is I'm right most of the time.
ACG TM1 / Essbase Consulting
Server(s): Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client(s): Windows XP.
User avatar
jim wood
Site Admin
 
Posts: 2020
Joined: Wed May 14, 2008 1:51 pm
Location: 1639 Route 10, Suite 107, Parsippany, NJ
OLAP Product: TM1
Version: TM1 9.5.2 EV 9.5.0
Excel Version: 2007

Re: Trends for Processor speeds

Postby Steve Rowe » Tue Mar 31, 2009 8:52 am

Yes better multi-threading is OK up to a point, but it's only useful for
1. Deliver cached numbers to many users at the same time.
2. Calculating independent set of numbers.

In general terms 2 isn't that common in my experience. We are still left with a lack of raw grunt power these days, especially as we move into 64 bit world with larger models based on more detail.

I'm really disappointed with the speed of my current hardware and all it's doing is adding consolidations no rules or anything.

Can you even buy "fast" processors???
Cheers
User avatar
Steve Rowe
Site Admin
 
Posts: 1169
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 9.0 9.1 9.5
Excel Version: Nearly all of them

Re: Trends for Processor speeds

Postby jim wood » Tue Mar 31, 2009 10:30 am

It's called £800 of quad core with water cooling. Your boss think your building a gaming rig though!! :mrgreen:
Legal Advisory: These are my personal opions... My opinion is I'm right most of the time.
ACG TM1 / Essbase Consulting
Server(s): Windows Server 2008 SP1 64-bit. TM1 Version: 9.5.2 Client(s): Windows XP.
User avatar
jim wood
Site Admin
 
Posts: 2020
Joined: Wed May 14, 2008 1:51 pm
Location: 1639 Route 10, Suite 107, Parsippany, NJ
OLAP Product: TM1
Version: TM1 9.5.2 EV 9.5.0
Excel Version: 2007


Return to General

Who is online

Users browsing this forum: No registered users and 1 guest

Loading