Setting in-database optimization to improve flowchart performance
Using in-database optimization can improve flowchart performance. When in-database optimization is on, processing is done on the database server and output is stored in temporary tables on the database server whenever possible.
You can apply in-database optimization in two ways: globally and for individual flowcharts. The best practice is to turn off the global configuration setting and set the option at the flowchart level.
1.
To adjust the option globally, at the partition level:
a.
Choose Settings > Configuration.
b.
Choose Campaign > partitions > partition[n] > server > optimization.
c.
Set useInDbOptimization to TRUE (on) or FALSE (off).
2.
To override the option for an individual flowchart:
a.
Open a flowchart in Edit mode.
b.
Open the Admin menu Tiny person, pencil, and circle with menu arrow icon and select Advanced Settings.
c.
Select or clear Use In-DB Optimization during Flowchart Run.
When you save and run the flowchart, in-database processing will be used whenever possible, if you are using in-database optimization.
*
In-database processing cannot be done if you specify any limitations on the output cell size or if temporary tables are disabled for a process.
Details about in-database optimization
Copyright IBM Corporation 2015. All Rights Reserved.