Direct SQL For Incremental Deployments Slower Than Direct SQL For Full Deployment
Last updated on JUNE 06, 2018
Applies to:Oracle Commerce Platform - Version 11.2 and later
Information in this document applies to any platform.
On : 11.2 version, Content Administration (BCC, Deployment, Versioning, Projects, Workflows)
Direct SQL for Incremental Deployments - Slower Than Direct SQL For Full Deployment
We've switched to Direct SQL deployments. The Direct SQL mode is faster for full deployment, but we experienced that small incremental deployments are slower.
Here is a test case for incremental deploying of single asset:
1. Create an incremental project that changes an only single property on single asset element.
- change property displayName on single Category: Product Family asset.
2. Deploy project in Direct SQL mode.
The first deployment on local database took 13 minutes, the same with regular deployment mode only 2.5 minutes
We would like to know how the direct SQL mode is marking tables to deploy, and how to speed up Direct SQL incremental deployments for our Product Catalog.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms