Hi Konstantin, Would it be possible to enable debug logging when running the slow search and posting the logs with the detailed information in the issue? That will display exactly which queries were the slow ones so that we can locate the bottle neck and fix the issue.
On Mon, Oct 31, 2016 at 7:12 PM, 'Konstantin Orekhov' via Foreman users < foreman-users@googlegroups.com> wrote: > Hi, Ohad! > > While I absolutely agree that more targeted searches are more effective > and, in fact, are not affected by the issue above: > > # time curl -kSs -u admin:$PASS https://localhost/api/hosts?se > arch=name=test | jq '.' | grep total > "total": 1699, > "subtotal": 0, > > real 0m0.175s > user 0m0.044s > sys 0m0.068s > > # time curl -kSs -u admin:$PASS https://localhost/api/hosts?se > arch=name~ppm | jq '.' | grep total > "total": 1699, > "subtotal": 4, > > real 0m0.383s > user 0m0.048s > sys 0m0.073s > > "non-targeted" search used to work just fine as I mentioned in original > post, I just want to make sure this is not a bug or something that affects > the performance in 1.13. > > If this is an intended change in behavior, it needs to be called out, > IMHO. Maybe I missed that? > > Anyway, the issue has been filed - http://projects.theforeman.o > rg/issues/17143 > > Thanks for looking into this! > > -- > 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. > -- Have a nice day, Tomer Brisker Red Hat Engineering -- 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.
