Content Catalog Sync is taking too long or much time

[former_member1243713]

In SAP smart edit, When we are doing the Content catalog sync..! Its taking so much time

Some times we are aborting the process & we are trying again & it got worked

Can some one guide me what was the issue behind this...! Nowadays am frequently facing this

[cristiano-costa]

There's no simple answer for this question. There are several steps in order to improve performance of Catalog Synchronization. Here are few tips:

1. If SAP Commerce Cloud is where your implementation is hosted, a database analysis is necessary to find the expensive queries. If locally or on premise, JDBC logs can help.

2. Increasing the number of threads ( catalog.sync.workers ) in the service configuration or local.properties. On Cloud default value of this property is #cores, which calculates number of threads per CPU core.

3. Reduction of Root Types, i.e the ones coming from an external system. It should also be considered whether there is a need to synchronize product images and other media. There can be a really huge number of medias in the catalog and the media can have a very big impact on synchronization performance. In many cases the synchronization of media can just be avoided.

4. Ordering of root types. In case there are custom catalog item types, the ordering needs to be adapted according to the data model.

5. Disabling attributes. If some attributes are not needed in the Online catalog version then these can be removed from the synchronization rule.

6. Setting Sync languages. The languages of the catalog version should be set to ensure that only the localized values are copied for the supported languages.

7. Queries with missing indexes

8. You have some relations where one side of the relations has a high cardinality. For example I have seem one one project we have a category with 200K products. You can disable one side of the relation if this is the case (e.g. disable category.products)

credit: https://community.sap.com/t5/customer-relationship-management-q-a/content-catalog-sync-is-taking-too...