Originally posted by: UDOPS
Here is an example problem log. I track elapsed time at intervals by setting variables with the Date() methods.
Note how the database queries take more time than solving the model. The data retrieved for formulating the problem is between 800 and 900 records. The solution returned to the database consists of 462 records (a tuple for each binary variable = 1).
In the post processing block, if I comment out the database update, the time drops to a small value.
Start of Main Program, 06/08/2010 13:50:05 885
Set of problems queued in FileMaker: {1515}
Time elapsed retrieving queue 2.234 seconds
Problem this loop: 1515
Time elapsed constructing query 0.016 seconds
Composing model
Pre-Process block.
Time elapsed making query and generating model 542.703 seconds
-
Solving master model**************
Time elapsed solving problem 600.234 seconds
Post-processing executed at end of master problem.
Time elapsed post processing 361.344 seconds
Solution obtained: {<11 15.52 16.75 163852 86117 976 1515>}
#DecisionOptimization#OPLusingCPLEXOptimizer