Q: How can I speed up my Evolver Optimizations?
A: There are a number of steps you can take to speed up Evolver optimization:
For large models, Evolver can use a large amount of memory. If you do not have enough physical (i.e. RAM) memory, it will page information to the hard disk. This can drastically slow down your optimization. Watch your hard-drive usage light while your optimizations are running. If it is constantly writing or reading information from disk, you should consider increasing your system's memory.
Multitasking is great, but other applications reduce the amount of available memory (see #1 above) and steal CPU cycles from Evolver. If you need to maximize the speed of your Evolver optimizations, try to close all unneeded applications.
Network traffic can slow things down. Try to install both Excel and Evolver locally, instead of running over a network. If you are running the network version of Evolver, choose the "Install Locally" option instead of the "Install Remotely" option.
This setting is located in the Evolver Options dialog. If it is set to Every Calculation, Evolver tells Excel to update its windows for the calculation of each trial solution. Depending on the model, this can account for a significant fraction of the optimization time. For maximum performance set the updating to Never.
If you have workbooks open that have nothing to do with your optimization, close them. Each trial solution, Evolver tells Excel to recalculate everything. Your extraneous open workbooks may take significant time to calculate.
Consider removing unnecessary graphs, graphics, and tables from your model. These may take significant time to calculate and update.
In Evolver 4.0.4 and earlier, the default temporary directory for Evolver is the same as the default windows temporary directory. In Evolver 4.0.5 and higher, Evolver's temporary directory defaults to a subdirectory of the DTOOLS directory (e.g. C:\DTOOLS\TEMP). You can always determine the temporary directory used by Evolver by looking in the DTOOLS.INI file in your windows directory. Go to that directory and clear out unused temporary files.
In general, hard constraints (specified in the Constraint Definition dialog) can not be evaluated until a particular trial has been calculated in Excel. If the hard constraint is not met, then that solution is tossed out by Evolver. Range constraints (which are specified for the recipe and budget solving methods in the Adjustable Cells dialog) are much more efficient because Evolver will never generate a trial solution that does not meet these constraints. See Also No Valid Solutions.