Apply Configuration time too long

[salami]

Hi,
I have a single nagios XI instance with more than 12K host with mod_gearman and two external worker. Also, I separate DB from main server on a remote host. all of my servers are CentOS 7 and Nagios XI version is 5.1.1
when I change any configuration on any host, i should apply configuration and about 2.5 minutes to apply configs and reload data. I received "configuration applied" message after 30 seconds but it spent about 2 min to reload data.
Is there any solution to prevent this kind of treat such as loading just "not applied" configuration instead of all configuration?

Also, when I want to go to CCM hosts item, because of number of devices added to system, it's too slow to load this item page. when I search a device in search section the issue recovered. seems all the hosts list need to be load then pagination will apply on the page.
would you please help me in this regard?

hardware spec of device are as below:
main server:
cpu: 10 cores
RAM: 4 GB

DB server:
cpu: 4 cores
RAM: 4 GB

worker servers:
CPU: 4 cores
RAM: 4GB

[scottwilkerson]

Also, when I want to go to CCM hosts item, because of number of devices added to system, it's too slow to load this item page. when I search a device in search section the issue recovered. seems all the hosts list need to be load then pagination will apply on the page.
would you please help me in this regard?

Several of these items have been improved upon when you compare your version to the current 5.5.2, including the above.

However, the time it takes for nagios to populate all your hosts and services in the DB after restarting nagios is really dependent on how fast your network and database server can run all the queries (tens of thousands). Very fast array of SSD's on the database server could help, but You are likely reaching a point that you may need to think about splitting into multiple nagios server and segregate then to keep their performance at peak.