We have a customer who is using hybris 5.4.0.0. The issue is that Catalog Synchronization job is performing very poorly updating only 3 items/sec.
Few observations that we made when JDBC logging is turned on.
The following statement on product is getting executed for 53 times 208|master|150920-20:16:20:332|0 ms|statement|UPDATE products SET hjmpTS = ? ,modifiedTS=? WHERE PK = ? |UPDATE products SET hjmpTS = 1462 ,modifiedTS='2015-09-20 20:16:20.331' WHERE PK = 8796199387137
The following statement is getting execute for 10 times for each productfeature that exists for a given product
186|master|150920-20:14:38:753|1 ms|statement|UPDATE productfeatures SET hjmpTS = ? ,modifiedTS=? WHERE PK = ? |UPDATE productfeatures SET hjmpTS = 123 ,modifiedTS='2015-09-20 20:14:38.752' WHERE PK = 8798096491107