| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2007 vs XL203 speed
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 V Liengme www.stfx.ca/people/bliengme remove caps from email |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
"Bernard Liengme" wrote...
.... one expects newer versions to be faster! 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
On 26 Mar 2007 23:01:59 -0700, "Harlan Grove" wrote:
"Bernard Liengme" wrote... ... one expects newer versions to be faster! 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. Harlan, you forgot to put a "smiley" after the above response. :-)( |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
"Jay Somerset " wrote in message
... Harlan, you forgot to put a "smiley" after the above response. :-)( Harlan? Smiley? <g -- Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
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 -- Dana DeLouis Windows XP & Office 2007 "Bernard Liengme" wrote in message ... 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 V Liengme www.stfx.ca/people/bliengme remove caps from email |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
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. "Bernard Liengme" wrote: 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 V Liengme www.stfx.ca/people/bliengme remove caps from email |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
"Dana DeLouis" wrote...
Just throwing this out. I would be curious to learn if setting it to 1, instead of Automatic, makes a difference... Application.MultiThreadedCalculation.ThreadCoun t = 1 'Solver here... Reset back to default... .... 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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
XL2007 vs XL203 speed
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 DTHIS 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" wrote in message ... 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 -- Dana DeLouis Windows XP & Office 2007 "Bernard Liengme" wrote in message ... 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 V Liengme www.stfx.ca/people/bliengme remove caps from email |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| There's no export to dbf files from XL2007? | Excel Discussion (Misc queries) | |||
| XL2007 - password protect workbook? | Excel Discussion (Misc queries) | |||
| XL2007 Copy As Picture | Excel Discussion (Misc queries) | |||
| XL2003 inconsistency fixed in XL2007? | Excel Worksheet Functions | |||
| XL2007 and array of sheet names? | Excel Discussion (Misc queries) | |||
Linear Mode
