Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile
Deb007
Level 4

10-01-2018

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

10-01-2018

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.

Answers (3)

Answers (3)

Avatar

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile
Deb007
Level 4

12-01-2018

Hi Vipul,

This is on cloud.

Regards,

Debabrata Tripathy

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

369 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

11-01-2018

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

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile

Avatar
Boost 25
Level 4
Deb007
Level 4

Likes

48 likes

Total Posts

85 posts

Correct Reply

22 solutions
Top badges earned
Boost 25
Affirm 10
Applaud 5
Give Back 5
Establish
View profile
Deb007
Level 4

11-01-2018

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.