Is there any limitation of number of attributes in work item?
![](http://jazz.net/_images/myphoto/3b1dda18730fc3c44e4b421193269335.jpg)
We were wondering how RTC behaves when it has a custom work item type with potentially several hundred attributes(60% are enum, 40% strings). Has anyone experience with performance?
Many of the attributes will remain empty (it's a catch-all WI Type, with various tabs....only some of which will be filled)
Does RTC allocate storage if the fields are empty? We are conscious that we don't want our databases to explode in size)
Shane
Many of the attributes will remain empty (it's a catch-all WI Type, with various tabs....only some of which will be filled)
Does RTC allocate storage if the fields are empty? We are conscious that we don't want our databases to explode in size)
Shane
Accepted answer
![](http://jazz.net/_images/myphoto/3b1dda18730fc3c44e4b421193269335.jpg)
There is a limitation. We generally limit to (I think) 100 attributes per workitem type and 500 overall, per project.
This is mainly for performance reasons.
There was documentation on this, I will try to find it.
This is mainly for performance reasons.
There was documentation on this, I will try to find it.
Comments
![](http://jazz.net/_images/myphoto/3b1dda18730fc3c44e4b421193269335.jpg)
Hi Piotr,
Thanks for that. If you can get the documentation it would be great....
Shane.
![](http://jazz.net/_images/myphoto/47c2590b8510c9d7973ef1dcd4d45b70.jpg)
here it is:
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/index.jsp?topic=%2Fcom.ibm.team.workitem.doc%2Ftopics%2Ft_customizing_work_items.html
"Attention: Each work item type can support up to 100 custom attributes."