Performance consideration for enumeration with 10,000 literals (Db or process spec)
Enum has 10,000 literals. In my local env, which runs Derby Db & WAS Liberty profile, When enum is configured for process spec, it takes 30 seconds to populate the list in the Picker. But our production is an enterprise level system with WAS & DB2.
For a better performance, should this enum be stored in database or process spec.
In my organization, only admin can edit the enum list.