Edit the \ESFM_HOME\FMServerSettings.properties file to contain the following settings.
Modified Server Settings need to be uncommented to take effect.
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 |
This value should be set to 10% of current heap size or 2GB (2000000000 bytes), whichever value is lower |
database.querycache.maxResultsetBytes |
This value should be set to 1% of current heap size or 200MB (200000000 bytes), whichever value is lower. |
server.cache.task.maxSize |
Task Row Count plus 5000 |
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.