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.
About this task
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.
Procedure
- To adjust the option globally, at the partition level:
- Choose .
- Choose .
- Set useInDbOptimization to TRUE (on)
or FALSE (off).
- To override the option for an individual flowchart:
- Open a flowchart in Edit mode.
-
Open the Admin menu
and select Advanced settings.
-
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.
Note: 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.