On Sat, Oct 29, 2016 at 11:49 PM, 'Konstantin Orekhov' via Foreman users <
foreman-users@googlegroups.com> wrote:
> Corresponding logs (WebUI search):
>
> 2016-10-28 18:39:29 a607439e [app] [I] Parameters: {"utf8"=>"✓",
> "search"=>"test"}
> 2016-10-28 18:40:16 a607439e [app] [I] Rendered hosts/_list.html.erb
> (10.1ms)
> 2016-10-28 18:40:16 a607439e [app] [I] Rendered hosts/index.html.erb
> within layouts/application (18.0ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Rendered
> common/_searchbar.html.erb (11.6ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Rendered
> layouts/_application_content.html.erb (12.2ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Rendered
> home/_user_dropdown.html.erb (1.9ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Read fragment
> views/tabs_and_title_records-6 (1.1ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Rendered home/_topbar.html.erb
> (43.9ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Rendered layouts/base.html.erb
> (45.5ms)
> 2016-10-28 18:40:17 a607439e [app] [I] Completed 200 OK in 47691ms (Views:
> 73.3ms | ActiveRecord: 47585.0ms)
>
> API:
> 2016-10-29 13:44:51 8a9d5e4a [app] [I] Started GET
> "/api/hosts?search=test" for 127.0.0.1 at 2016-10-29 13:44:51 -0700
> 2016-10-29 13:44:51 8a9d5e4a [app] [I] Processing by
> Api::V2::HostsController#index as JSON
> 2016-10-29 13:44:51 8a9d5e4a [app] [I] Parameters: {"search"=>"test",
> "apiv"=>"v2"}
> 2016-10-29 13:44:51 8a9d5e4a [app] [I] Authorized user admin(Admin User)
> 2016-10-29 13:46:10 8a9d5e4a [app] [I] Rendered
> api/v2/hosts/index.json.rabl within api/v2/layouts/index_layout (58.6ms)
> 2016-10-29 13:47:28 8a9d5e4a [app] [I] Completed 200 OK in 156710ms
> (Views: 62.3ms | ActiveRecord: 156519.5ms)
>
> Feel like a regression to me...
>
first of all, querying for a specific attribute (e.g. like name = foo, or
environment ~ prod) will always be dramatically faster, use bookmarks if it
becomes a complex query.
It seems that a search on additional attributes were introduce, and those
might slow up the request, you can probably enable slow sql queries on your
db to see the full query and which one is slow.
it can also change, if you installed plugins that enabled more search
attributes, again for the same logic, unstructured query (e.g. like test)
will have to go though all search enabled field. if you can narrow down
which one is slowing it down, we can change it to become available only via
explicit query (e.g. only if you specify it - mac = ..).
in any case, please open an issue to track this.
hope this helps,
Ohad
--
> 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.
>
--
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.
