Hi, we have a huge performance problem on the puppet class view. It takes abount 30 seconds to open the page.
2016-10-13 08:21:47 4d13dccb [app] [I] Started GET "/puppetclasses" for 172.29.70.9 at 2016-10-13 08:21:47 +0200 2016-10-13 08:21:47 4d13dccb [app] [I] Processing by PuppetclassesController#index as HTML 2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: _session_id:4d13dccb22fd168676dfa37aa39b7057 2016-10-13 08:21:47 4d13dccb [app] [D] Setting current user thread-local variable to mtnu 2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: authorize_login_delegation 2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: authorize_login_delegation 2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: idle_timeout 2016-10-13 08:21:47 4d13dccb [app] [D] Setting current organization thread-local variable to zed 2016-10-13 08:21:47 4d13dccb [app] [D] Cache read: entries_per_page 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered puppetclasses/index.html.erb within layouts/application (909.7ms) 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered common/_searchbar.html.erb (5.5ms) 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered layouts/_application_content.html.erb (6.0ms) 2016-10-13 08:22:16 4d13dccb [app] [D] Cache read: use_gravatar 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered home/_user_dropdown.html.erb (2.8ms) 2016-10-13 08:22:16 4d13dccb [app] [D] Cache read: views/tabs_and_title_records-8 ({:skip_digest=>true}) 2016-10-13 08:22:16 4d13dccb [app] [I] Read fragment views/tabs_and_title_records-8 (0.3ms) 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered home/_topbar.html.erb (7.1ms) 2016-10-13 08:22:16 4d13dccb [app] [I] Rendered layouts/base.html.erb (8.9ms) 2016-10-13 08:22:16 4d13dccb [app] [I] Completed 200 OK in 28831ms (Views: 901.8ms | ActiveRecord: 4243.4ms) 2016-10-13 08:22:16 4d13dccb [app] [D] Cache write: _session_id:4d13dccb22fd168676dfa37aa39b7057 ({:expires_in=>86400}) We have 289 Puppetclasses importet in foreman. We are using the organization feature, so users can only manage the puppetclasses that they have importet on the smart proxy which belongs to their organization. This is filtered via user groups and permissions. The permission for viewing the classes is "environment ~ $org_name". (The environments of the organizations beginns with the name of the organization.) If we search for a puppetclass that only one organization use, the search takes only about 10 secounds. But if we search for a class almost all organizations use, the search takes several minutes and the foreman processes eats almost all ram on the server. The log above shows that Views and DB are quick, but the complete request takes 28831ms. Is there a way we can debug this? We are using Foreman 1.13.0 Thanks for your help! Martin -- You received this message because you are subscribed to the Google Groups "Foreman users" group. To unsubscribe from this group and stop receiving emails from it, send an email to foreman-users+unsubscr...@googlegroups.com. To post to this group, send email to foreman-users@googlegroups.com. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.