|
|
||||||
|
#1
03-26-07, 09:44 PM
|
|
|
|
|
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! |
|
|
|
#2
03-27-07, 07:01 AM
|
|
|
|
|
"Bernard Liengme" <blien> 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
03-27-07, 03:17 PM
|
|
|
|
|
On 26 Mar 2007 23:01:59 -0700, "Harlan Grove" <hrlngrv> wrote:
> "Bernard Liengme" <blien> 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
03-27-07, 08:10 PM
|
|
|
|
|
"Jay Somerset >" <<jay-1941-> wrote in message
news:30cm > Harlan, you forgot to put a "smiley" after the above response. :-)( Harlan? Smiley? <g> |
|
#5
03-27-07, 08:36 PM
|
|
|
|
|
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 |
|
#6
03-28-07, 12:19 AM
|
|
|
|
|
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: [..] |
|
#7
03-28-07, 06:23 PM
|
|
|
|
|
"Dana DeLouis" <ddelo> 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
03-31-07, 11:15 AM
|
|
|
|
|
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 |
|
|
| Similar Threads | |
| Speed Speed Speed - Cutting down on wasted cycles I'm a professional novice. What is that? Someone who has been programming for many years but has never really moved beyond novice status because programming is not my core... |
|
| xl2007 speed issues I have read multiple threads here regarding speed issues and xl2007. They all have said that it has to do with charting or lack of SP1. So what if I don't create charts... |
|
| xl2007 How can I control xl2007 ribbons, are they the same as commandbars? Are the settings held in an xlb file? Is there a switch to turn them on/off? Many... |
|
| FileSearch gone in XL2007? I don't have it but just heard this. Really? If so, then to build a list of files in multiple directories, would we be required to devise a recursive blend of chdir and dir? ... |
|
| Max row Height in XL2007 Hi What is the maximum row height in Excel 2007. In 2003 it was 409.5, has this been increased? Also does anyone know how many characters can be placed in one... |
|
|
All times are GMT. The time now is 09:53 PM. | Privacy Policy
|
XL2007 vs XL203 speed