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 Lowest |
database.querycache.maxResultsetBytes |
% of java heap or 200,000,000 bytes (200 MB), whichever is the lowest. |
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.