In that case we would recommend you spliting this custom field im more thatn one if possible. What happens is that every time an issue with this custom field is created, all the 2000 values will be loaded and it will impact in your performance but it will depend on the number os users and hardware that you have for it.
Hope it Helps,
I am researching anotherr field that has 18000 values. Impact to issue creaation was about 2 seconds to display the creaate screen.
Question about updaating this field directly via DB update: if we another option and update the sort order to alphabeticaally sort these vaalues, will this impact population of this value in other issues?
Value A, sort order 1
Value C, sort order 2
Value A, sort order 1
Value B, sort order 2
Value C, sort order 3
Issue 1 originally has Value C, then I update the list, is it still Value C?
Just want to verify that sort order does not impact value selection.
18,000 values is suicidal - it's completely unusable for your humans (actually 2,000 is unusable and pointless for your humans), and is going to put quite load on everything.
You can't update a field via DB updates, unless Jira is completely offline (I don't know if that's the plan, but it needs to be), but amending the sort order won't affect the values.
It is a part of how we use Jira. We are transportation company that deals with any and aall shippers globally. We have a global list of carriers and that is the list. We want to bee able to ceentrally manage the options in this list. Sure some of them are not activve and willl not make the final list, just investigating and testing worste case. Performance impact to create an issue (granted it is in a project with low usage) was only 2 seconds to display the create isssue screen
With 18,000 options, it's not going to be 2 seconds.
Essentially, your data model is unusable as it is, you need to break it down in a useful way for your humans. There are no plugins that are going to be able to handle 18k options in a useful way.
You might be better off simply telling your users to use labels, and then reporting on them.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot