Page Comparison

...

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.

• Caveat: If you are not using SQL Parser, then only sqlrules would apply in sql_direct folder.  (Other types of rules and forecast modeling do NOT apply in the sql_direct folder if you are not using SQL Parser for Oracle.)
• If you are using Oracle with Datical DB 56.9 15 or higher you could consider using SQL Parser for Oracle to add forecast modeling and forecast rules.
  • SQL Parser for Oracle is applicable by default to the data_dml folder (packageMethod=data_dml) and sql_direct folder (packageMethod=direct) and sql folder (packageMethod=sqlfile).
   
  • Note that there were important improvements to the SQL Parser for Oracle in Datical DB 6.15.
  • Please see this page → Using SQL Parser  
  • You could also opt to set packageMethod=direct for your ddl folder so that folder would also use SQL Parser.  Using SQL Parser with packageMethod=direct for ddl would be faster than using the packageMethod=convert for ddl (convert is the default for ddl)
  • Please see these pages:
    • Using SQL Parser
    • Flexible Folder Names
    • How To: Choose Between CONVERT (ddl) and DIRECT (sql_direct) Packaging Methods

10.  Having the build agent and the database in close proximity can help performance.

...