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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/foreman-users. For more options, visit https://groups.google.com/d/optout.
