Skip to Content
0
Sep 21, 2015 at 05:02 AM

How to turn off un-necessary updates to hjmpTS and to modifiedTS

473 Views

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