Power Custom Fields PRO™ is becoming Power Custom Fields Premium™
Power Custom Fields PRO™ is being upgraded to Power Custom Fields Premium™. We are removing Power Custom Fields PRO™ from the market to focus resources on the combined app, Power Custom Fields Premium™ which has all the features of PRO™ and more. Existing Power Custom Fields PRO™ users can get 65% off their new Power Custom Fields Premium™ license by following the steps here.
I have a huge list in my database and it takes some time to display options
Power Custom Fields PRO™ runs an SQL query every time when a user tries to pull up a screen that contains one of the custom fields. The performance of the custom field cannot exceed the performance of the query when run directly from the database. So, if you have a query that takes 10 seconds to run when running from the database console it will take 10 seconds to run for the custom field. So for instance if you have 5 thousand users who are running a 10-second query every time they go to create a new issue or edit an issue this might have an impact on the performance of the database and increase the response time of Jira when it is running its own queries against the database. This would be true of any database plugin custom field, not just those developed by Cprime.
There are some design changes that could be used to mitigate the performance risks. For example, you could run the custom fields from a database cluster that is separate from the main Jira database. Also, using normalization on the tables and indexes targeted to the way the custom fields will be searching the tables will increase the performance of the custom fields.