Edit the \ESFM_HOME\FMServerSettings.properties file to contain the following settings.
Server Setting |
Value |
---|---|
datasource.read.timeout |
600 |
datasource.update.timeout |
120 |
server.GCThreshold.thresholdPercent |
85 |
server.ESThreadPoolSize |
200 |
server.CoreESThreadPoolSize |
200 |
server.JDBCBatch.enableForTransaction |
true |
server.enableAuditAttributeSystem |
false |
server.enableAuditSpreadsheetSystem |
false |
database.storeAuditAttributeXML |
false |
server.enableAuditWorksheetSystem |
false |
server.enableAuditActionSystem |
false |
database.querycache.maxcachebytes |
10% or 2 GB whichever is the highest |
database.querycache.maxResultsetBytes |
1% or 200 MB whichever is the highest |
These settings already exist in the file with default values. Modify the existing settings to the recommended value. Do not create new settings as it will cause conflicts when there are duplicate settings. The values in the table are standard recommendations and may need to be modified for specific requirements.