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.
Set SERVER=false (which disables agents and the operations console web application)
Set CLUSTER_NETWORKING_ENABLED=false (but this disables agents and reduces the information displayed on the console regarding executing file transfers)
Minimize or eliminate the use of prescripts and postscripts since these involve the interactive execution of code within workflows and reduce performance
Set RUN_HISTORY_ENABLED=false to turn off run history data collection
Set FLOW_CHART_DEADLINES_ENABLED=false to turn off checking for flowchart deadlines
Set AUDIT_TRAIL_FILTER.0= (and no other audit trail filters are present or all others are commented out)
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 http://msdn.microsoft.com/en-us/library/ms378988.aspx :
'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.'