Performance Impact Of custom field with 2000 values

ROGER PICKETT March 2, 2014

Is there any performance impact when aa custom field single select drop down list is populated with 2000 values?

2 answers

1 accepted

0 votes
Answer accepted
RicardoA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 2, 2014

Hi Roger

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,

Ricardo Carracedo.

ROGER PICKETT March 2, 2014

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?

Exaample

Current

Value A, sort order 1

Value C, sort order 2

Updated

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.

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 2, 2014

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.

ROGER PICKETT March 2, 2014

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

ROGER PICKETT March 2, 2014

Is it possible to have an auto-complete search be performed. Natively or via a plugin that allows for a new type of custom field that can autocomplete or lazy load values via search?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 2, 2014

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.

ROGER PICKETT March 3, 2014

Thanks your your time today. We will investigate otheer options.

1 vote
Radu Dumitriu
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 2, 2014

Who is able to browse 2000 values, anyway? I have a mental overflow at 100.

Suggest an answer

Log in or Sign up to answer