Hi, I have data for 500 rows in external table which I am trying to delete on ba

JANARDHNA KETHA over 8 years ago

Hi, I have data for 500 rows in external table which I am trying to delete on batches 50 using "Delete from data store entity" I constructing pv variable of type entityDataIdentifier as {entity:cons!DATA_STORE_ENTITY, identifiers:pv!ResultIDs}. But I am getting health check issues saying that "5500 ms as peak average "

Please suggest on this how to avoid from health check list

Discussion posts and replies are publicly visible

Parents

0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Janardhan, also please see if you have any feasibility of logical deletion rather than the hard delete options (ACTIVE_IN flag set to 'N'). hard deletes would be time consuming if you have any triggers to write to audit tables as well as if you are having any constraints dependent on them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 narasimhaadityac
A Score Level 2
over 8 years ago

Hi Janardhan, also please see if you have any feasibility of logical deletion rather than the hard delete options (ACTIVE_IN flag set to 'N'). hard deletes would be time consuming if you have any triggers to write to audit tables as well as if you are having any constraints dependent on them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data