Bug #14924
closed
taxonomies/edit.html.erb takes minutes to render
Added by Taylan Develioglu about 8 years ago.
Updated almost 6 years ago.
Category:
Organizations and Locations
|
Description
Trying to open the edit page of either a location or organization takes multiple minutes.
The time is spent rendering taxonomies/edit.html.erb and the passenger process stays ~100% utilization throughout the request.
Log attached is from rails environment set to `development`, notice that it takes over 6 minutes to complete the request.
Files
- Related to Bug #10893: Editing organizations/locations hangs in 1.8.2 added
Attached logfile with SQL logging enabled.
It shows a huge amount of this repeating:
2016-05-04 12:01:04 [sql] [D] CACHE (0.0ms) SELECT "templates".* FROM "templates" INNER JOIN "operatingsystems_provisioning_templates" ON "operatingsystems_provisioning_templates"."provisioning_template_id" = "templates"."id" INNER JOIN "operatingsystems" ON "operatingsystems"."id" = "operatingsystems_provisioning_templates"."operatingsystem_id" INNER JOIN "template_kinds" ON "template_kinds"."id" = "templates"."template_kind_id" INNER JOIN "template_combinations" ON "template_combinations"."provisioning_template_id" = "templates"."id" WHERE "templates"."type" IN ('ProvisioningTemplate') AND "operatingsystems"."id" = 1 AND "template_kinds"."name" = 'provision' AND "template_combinations"."hostgroup_id" IS NULL AND "template_combinations"."environment_id" = 1 ORDER BY templates.name LIMIT 1
- Status changed from New to Assigned
- Assignee set to Tomer Brisker
- Status changed from Assigned to Ready For Testing
- Pull request https://github.com/theforeman/foreman/pull/3491 added
I see a significant improvement with PR 3491 active. Wallclock went down from ~6 minutes to ~1 minute. Kudos!.
I do still notice a lot of repeat sql queries being done, however (see attached log).
The final PR reduced wallclock time to ~20s! \o/
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
- translation missing: en.field_release set to 136
- Bugzilla link set to 1396642
- Has duplicate Bug #10138: Manage Location and Organization unusable once thousands of nodes are assigned added
- Target version set to 1.4.3
Also available in: Atom
PDF