Bug 1732657

Created attachment 1593052 [details]
6.5 production.log

Description of problem:
Client registration on Satellite 6.5 is really slow compared to 6.4 - some customer logs show registration can be about nine times slower.

Version-Release number of selected component (if applicable):
Satellite 6.5

How reproducible:
Always

Steps to Reproduce:
1. Register a client to Satellite 6.4. Note the time and corresponding logs in /var/log/foreman/production.log. A sample is attached.
2. Unregister the client from Satellite 6.4.
3. Register the same to Satellite 6.5. Note the time and corresponding logs in /var/log/foreman/production.log. A sample is attached.

Actual results:
Satellite 6.5 registration is slower than 6.4. In my test:
Satellite 6.4 registration -> 2266ms
Satellite 6.5 registration -> 2396ms 
In my test, it looks like it is a bit slower in 6.5 but note that my hardware configuration:
Satellite 6.5 - 16GB RAM, Capsule 6.5 - 12GB RAM
Satellite 6.4 -  8GB RAM, Capsule 6.4 -  3GB RAM

In one of the customer logs:
On 6.4.3 - Registration ranged from 14ms to  17 sec
On 6.5.1 - Registration ranged from 16ms to 159 sec 

Expected results:
Registration times on 6.5 should be equal to or better than in 6.4.

Additional info:
See the attached logs - For the same client,
Satellite 6.4 creates 9 audit calls.
Satellite 6.5 creates 100 audit calls.

Please be aware that Audit calls are very expensive in production due to the size of audit tables in customers.  Two open bugs exist on this:
BZ1703490 - Satellite Audits page is very slow
BZ1703496 - [RFE] Satellite audits cleanup