Shimon Shtein

  • Email:
  • Registered on: 12/02/2014

Projects

Activity

Reported issues: 93

03/14/2017

09:02 AM Foreman Bug #18843 (Closed): Change eager_load to includes statement in hosts api controller's index action
Applied in changeset commit:a60d71e65b063a84f637ed4d17d0053038da9da5.
08:22 AM Foreman Revision a60d71e6: Fixes #18843 - Changed from eager_load to includes in #index
Avoiding multiple joins that result in very wide result rows.
It leads to big memory footprint in the DB especially o...

03/13/2017

08:40 AM Foreman Bug #18877 (New): Fix Host::Managed#bmc_nic performance
Two issues with this method:
1. It uses a scope (bmc) to access the interfaces which causes a query, even if the int...
08:28 AM Foreman Bug #18875 (New): Fix *_name methods to use cached association
app/models/concerns/has_many_common.rb defines a *_name methods for each belongs_to association.
The problem is that...
04:01 AM OpenSCAP Bug #18841 (Closed): Avoid N+1 query in foreman hosts index by declaring proper scope
Applied in changeset commit:foreman_openscap|901f778720f441746e296edd363f8a37c5e73975.

03/12/2017

06:30 AM OpenSCAP Revision 901f7787 (foreman_openscap): Fixes #18841 - Added policies to hosts index api scope
Policies are loaded while calculating compliance status, to avoid
N+1 query we are preloading them.
05:34 AM Foreman Remote Execution Bug #18842: Avoid N+1 query in foreman hosts index by declaring proper scope
In general, I think that the most effective performance optimization in _not_ calling a method.
If we can cache the ...

03/08/2017

10:40 AM Katello Bug #18845 (New): Avoid N+1 query in foreman hosts index by declaring proper scope
The following query is executed for each host during api hosts controller's index action:...
10:33 AM Foreman Bug #18843 (Closed): Change eager_load to includes statement in hosts api controller's index action
Since the query is pretty wide (contains multiple joins) the execution plan will try to make all joins and only then ...
10:18 AM Foreman Remote Execution Bug #18842 (New): Avoid N+1 query in foreman hosts index by declaring proper scope
The query following query gets executed N time during host index API call:...

Also available in: Atom