I am working on an optimization problem that exists of diverse formulas and attributes. The type of problem is comparable with the field of operations research. The challenge is to find a set of attributes with an optimal outcome. I tried to solve this type of problem with the parameter optimization loop. For an easy problem with for instance two formulas and iteration over 4 attributes this already takes much time. Adding attributes and formulas will increase the time exponentially. I have to use Brute force while the Hillclimbing option doesn’t give the right solution. I solved the performance problem by generating a list with all possible combinations of values and calculate the formula’s in parallel by using the table row to variable loop. But this leads to very long tables that exceed more than 100 million rows for 8 attributes. Two questions on this:
- Does Knime offers other kinds of support for the field of Operations research (comparable to the solver function in Excel)?
- I currently generate the table with all possible values of the attributes with the parameter optimization loop. But for 100 million rows I need this number of iterations which is very time consuming. Is a smarter way of generating this table possible?