Page Comparison

Overview

...

8.  For Oracle/SQL Server/DB2, change the Stored Logic Validity Check to "local" (the default) or "limited" or "disabled", depending on which features you actively useyou actively use.

• Please see the notes in these pages:
  
  • Stored Logic Validity Check details
  • Project Settings
• Performance recommendations:
  • If you do
   
  • not
   
  • review or use the information in the Stored Logic Validity Check section of your deploy reports, then set storedLogicValidityCheck="disabled" to avoid possible performance slow down for a feature you aren't actively using.
  • If you review and use the Stored Logic Validity Check information in your deploy reports but you do
   
  • not
   
  • use the
   
  • storedLogicValidityAction=FAIL option, then
  set 
  • we recommend setting storedLogicValidityCheck="limited".
  • If you review and use the Stored Logic Validity Check information in your deploy reports
   
  • and
   
  • you also have enabled the
   
  • storedLogicValidityAction=FAIL option, then
  set 
  • we recommend setting storedLogicValidityCheck="local".
  • Although
   
  • storedLogicValidityCheck="global" is an available setting and is the most comprehensive, if performance timing is an important consideration then it may be better to use a smaller scope such as "local" or "limited".
  Please see the notes in the "Stored Logic Validity Check" heading on this page: Configuring Project Settings
• There are different ways you can set the stored logic validity check level, use the method you prefer to set the value:
  • In the desktop client/Eclipse GUI, set it to limited.  See Stored Logic Validity Check here  → Configuring Project Settings
  • Set it using the hammer CLI command (example: "hammer set invalidsCheck limited").  See invalidsCheck here  → CLI Commands#set
  • If you use the optional project creator script, see invalidsCheck here  → Creating a Datical Project Using the Project Creation Script (project_creator.groovy)
  • In the datical.project file, this is represented as storedLogicValidityCheck="disabled" or storedLogicValidityCheck="limited" or storedLogicValidityCheck="local".

9.  Packaging ddl scripts from the sql_direct folder (packageMethod=direct) is typically faster than from the ddl folder (packageMethod=convert).  You could also opt to set packageMethod=direct for your ddl folder.

...