Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

Update data activity is taking too long to update bulk amount of data in recipient table.

Avatar

Community Advisor

Update data activity is taking too much time to run in Adobe Campaign while updating bulk amount of data in recipient table. Around 30 mins for updating 900000 number records. The table contains around 30 M records. The reconciliation key is having an index on it (it is the primary key column).Is there any scope for improvement?

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

Is your database in good health? Check the level of fragmentation of indexes and table and then decide if it needs a vacuum.

Always perform these bulk updates during a period of low activity as it can lead to page level locks causing blocking queries.

Check if there aren't too many indexes on this table as every insert/update also requires update or the index. If the index is too bloated additional slowness will be observed.

View solution in original post

4 Replies

Avatar

Correct answer by
Employee Advisor

Is your database in good health? Check the level of fragmentation of indexes and table and then decide if it needs a vacuum.

Always perform these bulk updates during a period of low activity as it can lead to page level locks causing blocking queries.

Check if there aren't too many indexes on this table as every insert/update also requires update or the index. If the index is too bloated additional slowness will be observed.

Avatar

Community Advisor

Hi Vipul,

Thanks for your input. I am doing it in low activity period only and other than out of the box indices, there are two more indices in the extended schema and I am only performing update. Next thing is the DB health, let me check that.

Avatar

Employee Advisor

If you instance is on-prem a good this will be check at infra level.

Disk IOPS is another factor. If the disk is responding slow nothing much can be done from the application standpoint.

Check if there is latency over the network just in case application and database are on different servers.

Use a better quality hard disk to see the performance gain.

Avatar

Community Advisor

Hi Vipul,

This is on cloud.

Regards,

Debabrata Tripathy