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.