Question2Replies218Views Deva_Prathapaneni Member since 2014 30 posts Cognizant Posted: April 14, 2019Last activity: April 25, 2019 Closed Solved Case create commit takes more than 10 secs.Hi All,We are creating CPM interaction case and we are receiving PEGA0002 alert in CommitWithErrorHandling activity. When we analayse the DB queries executed in it is as follows in secs.1. Work table insert query- 0.0140 2. Pca_indexinteraction merge query - 0.0110 3. Pc_assign_worklist merge query - 0.0130 4. History insert query-0.0030But end of this query execution i can find PEGA0002 with 14 secs. Not able to find any other queries or commits.How to find where is this time taken. Thanks,Deva Low-Code App Development Dev/Designer Studio ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 1 year agoKevinZheng_GCS PEGA replied to Deva_PrathapaneniIf you turn on the debug log of the activity, you should see which step taking how much time: Rule_Obj_Activity.commitWithErrorHandling.Work_.Action Is it 'commit' step? If yes, it may be due to deferred save, which takes more time than individual query. Accepted Solution Posted: 1 year agoDeva_Prathapaneni Cognizant replied to Deva_PrathapaneniWe have Materialized view is executing on commit that causes the slowness of workobject commit.