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.