XL2007 vs XL203 speed

  • Thread starter Thread starter Bernard Liengme
  • Start date Start date
B

Bernard Liengme

Just to add to the discuss:
I have a Solver model (engineering problem called the four-bar crank) with 2
variables and 73 constraints of the form a=0. In XL2003 this takes about 5
seconds; in XL2007 it takes 25 sec. A 1:5 ratio the wrong way around - one
expects newer versions to be faster!
 
Bernard Liengme said:
one expects newer versions to be faster!
Click to expand...

And it might be if you shelled out for a quad core PC with 4GB RAM and
a terabyte drive. You're probably starving the poor software with a
dual core and 512MB RAM.
 
And it might be if you shelled out for a quad core PC with 4GB RAM and
a terabyte drive. You're probably starving the poor software with a
dual core and 512MB RAM.
Click to expand...

Harlan, you forgot to put a "smiley" after the above response. :-)(
 
Harlan, you forgot to put a "smiley" after the above response. :-)(
Click to expand...

Harlan? Smiley?

<g>

--
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Just throwing this out. I would be curious to learn if setting it to 1,
instead of Automatic, makes a difference...

Application.MultiThreadedCalculation.ThreadCount = 1

'Solver here...

Reset back to default...

Application.MultiThreadedCalculation.ThreadMode = xlThreadModeAutomatic
 
On the same hardware, newer versions are ALWAYS SLOWER than older versions.
Either wait for a service pack that may or may not speed it up, or get a
better computer.
 
Dana DeLouis said:
Just throwing this out. I would be curious to learn if setting it
to 1, instead of Automatic, makes a difference...

Application.MultiThreadedCalculation.ThreadCount = 1

'Solver here...

Reset back to default...
Click to expand...
....

Begs the question why Solver would go fubar if run multithreaded. One
would have thought it was an obvious candidate for multithreading
since it could calculate objective functions and support given
constraints at the same time, not to mention displaying iteration
results.
 
How does this all perform in an xlsb file. This format is optimised for
speed. As eluded to, turning multi-calc off for non multi/dual core
processors will also speed things up

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

Dana DeLouis said:
Just throwing this out. I would be curious to learn if setting it to 1,
instead of Automatic, makes a difference...

Application.MultiThreadedCalculation.ThreadCount = 1

'Solver here...

Reset back to default...

Application.MultiThreadedCalculation.ThreadMode = xlThreadModeAutomatic
Click to expand...
 
Back
Top