There's a simple value list of a field that contains more than 50,000 records.
When user click a drop down list that using this value list in very first time the system started, sometimes it took a couple of minutes. (This is done on Azure server with not bad internet connection). After the load of the list is not bad.
Mostly like to know why it happens? and also is there a way to work around this? like doing something in start up script? waiting in the start up of the system is ok.
Any idea is appreciated.