[v6] I have a high consumption of primary key IDs, should I be worried?

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

29-09-2016

Most of the factory schemas in Adobe Campaign use the same sequence of ids for the primary key (XtkNewId). Custom schemas developed during the project phase will also use the same sequence of ids unless a specific sequence has been defined for them.

Therefore the more schemas there are using the out-of-the-box sequence, the higher the consumption of ids will be.

A high ID consumption very probably indicates a problem and should be investigated, the data import procedures being the likely culprits.

Note that in some cases, negative IDs can be supported.

See documentation.

 

Florent.