On the same note - after upgrading to 1.13.1 today, I immediately noticed the huge delays in search through the hosts in both WebUI and API (the latter is actually worse than WebUI). Here are few examples:
# time curl -kSs -u admin:$PASS https://localhost/api/hosts | jq '.' | grep total "total": 1695, "subtotal": 1695, real 0m0.816s user 0m0.040s sys 0m0.076s But the search through my 1695 hosts on this instances takes 2.5 minutes (!): # time curl -kSs -u admin:$PASS https://localhost/api/hosts?search=test | jq '.' | grep total "total": 1695, "subtotal": 1, real 2m25.147s user 0m0.053s sys 0m0.063s For comparison, the same operations in 1.7.1 (from which I migrated one of the instances) give these results: $ time curl -kSs -u korekhov:$PASS https://localhost/api/v2/hosts | jq '.' | grep total "total": 2561, "subtotal": 2561, real 0m1.057s user 0m0.014s sys 0m0.007s $ time curl -kSs -u korekhov:$PASS https://localhost/api/v2/hosts?search=test | jq '.' | grep total "total": 2561, "subtotal": 1, real 0m1.101s user 0m0.012s sys 0m0.007s Would much appreciate the help figuring this out. -- 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.