Now also looking to implement running excel in parallel across several instances. I haven't tried turning off the multi-threading, but will do.Ĭan some from AWS please confirm if there is a known problem with the excel multi-threading? Running the same task on my laptop (intel i7 2.0GHz, 64bit windows running 32bit excel) it is considerably faster. My performance measuring of the various tasks shows that it is the pure calculation speed in excel which takes time (despite my implementing controlled calculation using range.calculate and range.calculaterowmajororder etc). I ran an looping data sourcing and calculation process using 64bit SQL server express and 64bit excel 2010 and it took >24hours on a m2.xlarge instance, which was the fastest AWS instance i could find (so called 'high compute' instances were considerably slower). I've had a similar experience with slow excel/vba.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |