It's all about the answers!

Ask a question

Are there Performance impacts on having blank attributes on work items?

ed Neubecker (15322847) | asked Jul 25 '14, 4:15 p.m.
edited Jul 28 '14, 9:10 p.m.
A customer that has a highly customized RTC workitem  process is trying to understand "performance implications" to a design idea.

The Current design has 7 custom work item types, with a well defined parent-child relationship hierarchy of these work item types. (3 levels of hierarchy...not 7).
One of the work item types (in the 3rd level of hierarchy) would have a unique process rule that requires 15 custom attributes to be set. This occurs about 10% of the time.  If they add these 15 unique attributes to an existing work item, will the existence of these attributes (but empty 90% of the time) have any impacts on performance or DB size?
The attributes are all small/medium strings.

Accepted answer

permanent link
Ralph Schoon (63.3k33646) | answered Jul 29 '14, 2:28 a.m.

I would expect additional attribute values to have a minimal effect on the database size. More attributes also has a small performance impact e.g. on loading in the web UI. There is just no free lunch.

However, having said all that, I would not consider that as inhibitor for what you are trying to do.
ed Neubecker selected this answer as the correct answer

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.