Child pages
  • Performance Related Configuration Settings
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

The following settings have a significant impact on Flux performance. Setting them to these recommendations optimizes the engine for performance, at the expense of functionality, loss of history, or logging details.

  1. Set SERVER=false (but note that this disables agents and the operations console web application)
  3. Set CLUSTER_NETWORKING_ENABLED=false (but this disables agents and reduces the information displayed on the console regarding executing file transfers)
  4. Minimize or eliminate the use of prescripts and postscripts since these involve the interactive execution of code within workflows and reduce performance
  5. Set RUN_HISTORY_ENABLED=false to turn off run history data collection
  6. Set FLOW_CHART_DEADLINES_ENABLED=false to turn off checking for flowchart deadlines
  7. Set AUDIT_TRAIL_FILTER.0= (and no other audit trail filters are present or all others are commented out)
  8. Reduce the SYSTEM_DELAY=+2m to SYSTEM_DELAY=+5s

Specific to SQL Server Installations:

Using the connection string parameter selectMethod=cursor was required in old releases of SQL Server. In more recent versions, it is only needed if large result sets are being returned back to the client (generally more than 100 records at a time), and only if the client has insufficient memory to handle the returned result set. If this is turned on, the server returns results at 100 rows per call but at the expense of server performance. In testing Flux, the performance hit seems to be around 35-40% for Puts by themselves as illustrated in the SelectMethod.png attachment below. Puts and execution is also improved - as seen in SelectMethod 2.png. Removing this parameter from the SQL Server connection string should provide some significant performance gain.

Per the Microsoft website at :

'If this property is set to "cursor," a database cursor is created for each query created on the connection for TYPE_FORWARD_ONLY and CONCUR_READ_ONLY cursors. This property is typically required only if the application generates very large result sets that cannot be fully contained in client memory. When this property is set to "cursor," only a limited number of result set rows are retained in client memory. The default behavior is that all result set rows are retained in client memory. This behavior provides the fastest performance when the application is processing all rows.'




  • No labels