Dropd-down on edit view layout getting time to load the options

I have 4 different drop-down list on my edit view layout. I am pulling the drop-down options from the DB. I am having issue like: when I click on the drop-down list to select any options for first time it will load options quickly with 2-3 seconds. But if click outside and again click on the same drop-down list to select any option it will taking near about 1 Min.

Can any one help me in with this issue for drop-down. I is happening with all the drop-down list on my edit view layout

I am attaching screen-cast for the issue: https://www.screencast.com/t/u7Op4HRh

I am using SuiteCRM Version 7.11.8
Please suggest on this.

Thanks in advance.

Hi there,

So your not using the default implementation of the dropdowns? Pulling that many values from the database a shedload of times aren’t recommended, some kind of caching would be a good idea however I don’t see from that implementation why the default wouldn’t work for you.

More details about the setup would be great for helping folks jump into this thread.