From time to time certain settings need to be updated to improve Datical's deployment performance. This is especially true when you upgrade from an older version of Datical to a newer version which takes advantage of enhancements introduced in recent releases.
These are some settings that are known to improve deploy performance:
1. enableRowCount=”false” or "approximate" → /wiki/spaces/DDD/pages/24707471
- For Datical DB versions 5.6 or lower, set it to "false" to completely disable it
- For Datical DB versions 5.7 or higher, set it to the new "approximate" option
2. limitForecastProfiling=”true” → For more information on this topic: /wiki/spaces/DDD/pages/24707448
3. deployMode=”quick” → For more information on this topic: /wiki/spaces/DDD/pages/523272429
4. Stored Logic Validity Check="limited" → The "limited" option is only available in Datical DB 5.3 or higher: /wiki/spaces/DDD/pages/491290653
These settings can up changed from Datical GUI, or by using hammer set commands in the CLI, or by using the optional project_creator script. Notice the attributes near the end of this excerpt from the datical.project file:
<dbproject:Project xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dbproject="http://datical.com/db/project/1.0" name="dpe-datical-paymentmanager" storedLogicExternal="true" deployThreshold="stopOnError" runtimeCredentials="false" multiSchema="true" dbSchemaDefinition="project" schemaSelectionStep="PAMAND5" trackingSchema="DATICAL" storedLogicValidityCheck="limited" enableRowCount="approximate" limitForecastProfiling="true" deployMode="quick">
In the Datical desktop client/Eclipse GUI, you would set the above mentioned settings /wiki/spaces/DDOC59/pages/795804508:
- enableRowCount="approximate" → Select approximate for the Deployment Setting > "Collect row counts for all tables during Forecast (if needed for rules)"
- limitForecastProfiling="true" → Check the Deployment Setting > "Limit Forecast Profiling"
- deployMode="quick" → Check the Deployment Setting > "Full Deploy"
- In Datical GUI, make this change in Deployment Settings > Stored Logic Validity Check > select "Limited"
In the CLI, you can set those same items using "hammer set" commands for enableRowCount, limitForecastProfiling, deployMode, and invalidsCheck. Please see the set command details here: /wiki/spaces/DDOC59/pages/795771831
If you use the optional project_creator script, you can set these settings when initially creating the project: /wiki/spaces/DDOC59/pages/795804403
There are other performance improvement suggestions on these pages:
Related articles