Seems you're right about the subnets. For some reason it seems it's loading every single subnet. This happens after the "Added" debug log message though

I can confirm that the patch indeed solves the problem. However, it's still very slow (even with just the one subnet I added).

I'm a bit confused as to why it needs to re-read the full subnet after an add operation?

D, [2014-05-21T10:07:34.823707 #3788] DEBUG -- : true
D, [2014-05-21T10:07:34.823783 #3788] DEBUG -- : omshell: executed - set hardware-address = 00:50:56:00:00:00
D, [2014-05-21T10:07:34.823841 #3788] DEBUG -- : true
D, [2014-05-21T10:07:34.823935 #3788] DEBUG -- : omshell: executed - set hardware-type = 1
D, [2014-05-21T10:07:34.823987 #3788] DEBUG -- : true
D, [2014-05-21T10:07:34.824200 #3788] DEBUG -- : omshell: executed - set statements = "filename = \"pxelinux.0\"; next-server = 0a:2f:00:00; option host-name = \"host.fqdn\";"
D, [2014-05-21T10:07:34.824258 #3788] DEBUG -- : true
D, [2014-05-21T10:07:34.824334 #3788] DEBUG -- : omshell: executed - create
D, [2014-05-21T10:07:34.824386 #3788] DEBUG -- : true
I, [2014-05-21T10:07:34.847729 #3788] INFO -- : Added DHCP reservation for host.fqdn (1.1.1.1 / 00:50:56:00:00:00)
D, [2014-05-21T10:12:29.163547 #4709] DEBUG -- : Reading config file /etc/dhcpd.conf

Jon Skarpeteig wrote:

I'm a bit confused as to why it needs to re-read the full subnet after an add operation?

1. no need to keep another db in the proxy
2. easier to write

We could consider caching things (like list of subnets etc), but normally I think they whole list should not be loaded automatically, only for requests that need it, therefor, if it reloads the data after creating the record, there might be a hidden extra request coming from foreman which is not required?

Right now the foreman-proxy use several minutes to list a single C-class subnet. It's burning 100% CPU on a single thread until it's complete. As the GUI sits and waits for this process on both edit and save operation - it's a horrible user experience.

I'm getting this, when I try to upvote:

Internal error

An error occurred on the page you were trying to access.
If you continue to experience problems please contact your Redmine administrator for assistance.

If you are the Redmine administrator, check your log files for details about the error.

Hi,

I think the suggest IP that comes in the network tab of adding host page is what causes the load of entire subnet data (loadsubnetdata function) which is very expensive. For simple cases of addition Im not sure if it is needed since omshell should return an error on conflict etc. Please correct me if Im wrong.

Is there a way to disable the suggestion part ? Or is there any other cleaner work around for this?

Ohad Levy wrote:

Jon Skarpeteig wrote:

I'm a bit confused as to why it needs to re-read the full subnet after an add operation?

The proxy is a stateless API service, meaning, it does not remember anything between requests, this is done because:

1. no need to keep another db in the proxy
2. easier to write

We could consider caching things (like list of subnets etc), but normally I think they whole list should not be loaded automatically, only for requests that need it, therefor, if it reloads the data after creating the record, there might be a hidden extra request coming from foreman which is not required?

IP suggestion can be disabled in 1.6 (#6529), edit the Subnet in the UI and untick the IPAM checkbox.

Dominic Cleal wrote:

IP suggestion can be disabled in 1.6 (#6529), edit the Subnet in the UI and untick the IPAM checkbox.

Thanks Dominic . I tried it and didnt find much improvement. The perfomance penalty seems to be from loadSubnetData function which gets called 4 times while adding a new host (which Im not sure why) . Probably caching could be a solution to cut down its time by 4 .