I have a very long dropdown - nearly 400 items. Yes not a nice design but unfort

I have a very long dropdown - nearly 400 items. Yes not a nice design but unfortunately I am tied to this constraint and cannot change it. At the moment I have a nested rule which is deciding which constant to look up out of possible 18. I have transferred the data to a database and then changed the rule to call a query rule based on variable. However the performance is noticeable different the same rule is taking 3-4 seconds to return the result for the largest dataset. I have also tried to do the same based on a integer but the performance is the same. Is there anything anyone can recommend to get this working pulling from the db rather than constants quicker? I want it in the DB so it can be regularly updated and is scalable where the current every time we want to add a new ‘type’ we need to add a new set of constants....

OriginalPostID-64256

OriginalPostID-64256

  Discussion posts and replies are publicly visible