Product Synchronization lasts longer

[Former Member]

Hi experts, We use v5.2.0.6. Previously - on live since 2015 October- productCatalogSync-Staged->Online was taking about 2 minutes for first months. But nowadays it takes 2 hours. We have approximately 16000 products on Staged. Why does it take so much, what may be the cause of time increasing issue? Thank you

[Former Member]

There are a number of reasons why it could be slower

• Only the items that have changed are synchronized, maybe you have more data that is being changed now

• Maybe be you have some relations where one side of the relation has a lot of items. A common case is a Category that has thousands of Products

• You have many more items in some of the tables so queries that were fast before are now slow (might require indexes). A common case is CronJobs create a lot of JobLogs which are a subtype of Media item

If you enable JDBC logging you can find out which queries are taking a long time.

You also have the option to increase the number of worker threads if you haven't already which should reduce the synchronization time if the database is not the bottleneck.