Tag Length
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-03-17 07:28 PM
Is there a limitation to how long a tag can be?
How adverse to performance are longer tags?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-17 01:25 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-03-17 06:53 PM
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.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-03-17 01:34 PM
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.
