Skip to Content
0
Former Member
Feb 17, 2017 at 06:24 PM

Hybris system update taking long

425 Views

Hybris update on our production env and pre-prod env is taking 1.5 to 2 hours which way more than what our business allows. We are on Hybris 5.6

Options selected while running update:

1) Update running system

2) Localize types

3) Clear hmc config

Project data: A couple of extensions but their impex count is very limited and surely don't take long

Below are our findings;

1) We pulled the AWR report from our database while update was running and found that there were Update DML running on multiple tables which were taking long. Below are the DML stmts

 UPDATE pricerows SET modifiedTS=createdTS WHERE modifiedTS IS NULL
 
 UPDATE medias SET modifiedTS=createdTS WHERE modifiedTS IS NULL
 
 UPDATE itemsynctimestamps SET p_syncjob=0 WHERE p_syncjob IS NULL

Below are the details on the count of these tables

Pricerows -> 753516376

Medias -> 8815918

ItemSyntimestamps -> 76512157

2) I re-executed hybris update on pre-prod env after reducing the row count of these tables and it finished in 21 mins. Below were the new row counts

PRICEROWS -> 2463815

Medias -> 766

ITEMSYNCTIMESTAMPS -> 7677

3) Checked on prod and pre-prod env, there are no records in these 3 tables having MODIFIEDTS = NULL

Questions:

1) Why is hybris running this query?

2) Can this be skipped?

3) Is there any other option to optimize it?

Any help on this will be appreciated. Thanks