PSA Delete Step is Taking too long

[former_member229456]

Hi,

Can anyone please help me narrow down an issue where a scheduled "Delete PSA Request" that has historically taken no more than 5 minutes to complete (in process chain) is now taking more than 8 hours? What are some of the things that I can look at to determine why this is the case? Thanks in advance!

[Former Member · Accepted solution]

Hi ,

Normally index creation or deletion takes longer time when  your database statistics are not updated properly, so you can check databease stats after your data loading is completed and index generation is done.

If the following chain is running number of times in a day then you need not delete and create the Index again and again .

Then you can remove the delete and create index step from the Original chain and create an separate chain with delete and create index step and run it once when you have less load on the system .

Hope this helps .

Thanks