Product Catalog Synchronization takes more time.

[dattatraya_durgule]

Product catalog with 80K products in Staged Catalog Version takes around four hours to finished Synchronization Job(Staged -> Online). Is there any configuration which can speed up synchronization process?

• Hybris Version: 6.4

• Database: MySQL

• System RAM: 16GB

[Former Member]

Sure there is! Can you do JDBC logging?

https://help.hybris.com/6.7.0/hcd/8c072d3c86691014b47a9dfeaec0fe3f.html

[dattatraya_durgule]

Emre, Thank you for your suggestion.

I enabled the JDBC logging while synchronization and verified the generated log file, but not able get much from that. I can only see that major time spent on Commit statements. Due to large file size(970MB), not attaching it here. I have extracted Elapsed Time column from the file and attaching here for reference. Note: This file contains only unique list of Time Elapsed column.

link text

Is there anything that could help in this case?

10775-jdbc-logs-time.txt