Hide Forgot
Description of problem: In a Satellite environment where it has 2k+ hypervisors, it takes 15+ minutes to call this api to get a list for pools which is considerably slow. Version-Release number of selected component (if applicable): candlepin-2.6.9-1.el7sat.noarch How reproducible: Easy Steps to Reproduce: 1. set up a satellite server with 3k+ hypervisors. 2. call the api Actual results: It takes 15min+ for the api to return all the pools. Expected results: It shouldn't take this long.
Verified in Satellite 6.7 Snap 16. I pushed my system beyond 5k hypervisors and got the following results: irb(main):005:0> Benchmark.bm{|x| x.report{ Katello::Pool.get_for_owner('Default_Organization') }} user system total real 6.281571 0.585320 6.866891 ( 10.714442) => [#<Benchmark::Tms:0x000000002103d600 @label="", @real=10.714441663003527, @cstime=0.0, @cutime=0.0, @stime=0.5853199999999994, @utime=6.281571, @total=6.866890999999999>]
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHSA-2020:1454