cancel
Showing results for 
Search instead for 
Did you mean: 

Tag Length

JerryCrowley
Level 3
Is there a limitation to how long a tag can be? How adverse to performance are longer tags?
3 REPLIES 3

John__Carter
Staff
Staff
I think the tag field is nvarchar(255), but as Tolani says, tags are not intended for unique values. The idea is that they are categories, groups, labels etc, not things like Account IDs or phone numbers. When you have very many different tags the DB 'effort' to extract a queue item and all it's tags can increase.

JerryCrowley
Level 3
Thanks guys for the help! I'm using the tags for categorical reasons (with no personal data of course), so they're not completely unique.

Denis__Dennehy
Level 15
Tags should contain information that would help identify work type, scenario, or process path followed. This should usually be short descriptors such as: Invalid client, Funds transfered, Account closed, etc... Very large tags are likely to contain unique data and will probably reduce the efficiency of the Work Queue database tables.