K
K Dales
Any "pure" programming environment will be more efficient
than VBA, but I don't think it would speed things by the
order of magnitude you describe. I suspect you may need
to optimize your code better. The way you implement your
algorithm - especially any sorting/searching/looping, can
make a big difference in speed of execution. To me that
is the most likely explanation for such a vast difference
in speed of execution.
to run on a 3 gigaHz machine. I've seen demos where
100,000 scenarios run in less than 1 minute. I think I
need to learn a faster language to implement my macros.
Any recommendations? C++, C#, something else?
than VBA, but I don't think it would speed things by the
order of magnitude you describe. I suspect you may need
to optimize your code better. The way you implement your
algorithm - especially any sorting/searching/looping, can
make a big difference in speed of execution. To me that
is the most likely explanation for such a vast difference
in speed of execution.
runs 50,000 Monte Carlo simulations and it takes 3-4 hours
to run on a 3 gigaHz machine. I've seen demos where
100,000 scenarios run in less than 1 minute. I think I
need to learn a faster language to implement my macros.
Any recommendations? C++, C#, something else?