Speed up UPDATE process in MDM from Portal

[Former Member]

Hi Guys,

I am creating, updating business partner in MDM through portal. Initially 50k master entries were migrated to MDM from ECC.

Speed during data migration was OK. 10k records took 10-15 mins(manual import thru Excel file). Now problem comes when i create any new record in portal and press 'SAVE' button. it takes very long time(>20 mins) to get record saved in MDM.

what could be the issue here? is this from portal side or MDM side? how can i speed up the save process? can anything be done at database level?

Kindly provide your valuable suggestions on this.

Thanks in advance.

Regards.

[Former Member]

Hi Prashant

save should not take 20 minutes. Can you provide more details please?

How are you saving the record? Does it triggers a workflow? When does save happens- after the workflow steps?

regards

Ravi

[Former Member]

Hi Ravi,

yes, we are using workflow concept at protal level not in MDM. and save is happening before workflow is triggered. i mean after clicking on save, record gets created(saved) in MDM in checked-out state(like: 'New Item(304)' ) and when all workflow steps(all approvals) gets executed then customer no. is generated in MDM and record is syndicated to ecc.

but speed issue comes when first time record is saved in MDM.

let me know if you need some more info.

Regards.

[Former Member]

hi Prashant

hope the portal code is fine, not getting into any loop. Try to eliminate the problems, may be. Is the problem with code or with MDM repository? Use the same code on different MDM repository on different server may be nad see the behaviour, if this still takes 20 min for save.

Try to run verify command for the repository and repair/compact if needed.

regards

Ravi