Why is "Compensation - Salary Details Real Time" so slow
Summary:
We have an employee roster/list that uses "Compensation - Salary Details Real Time"
If we use 3 columns from that subject area (pairing with Person Seniority and Worker Assignment Real Time), it's a 18 minute run time. All the columns we're using are delivered (Annualized Salary, Current Salary, Compa-ratio)
If we build the report using Compensation Salary Details Real Time (pairing with Person Seniority), it's an 18 minute run time.
If we take out Person Seniority and run in just that single subject area (Compensation Salary Details Real Time), it's a 25 minute run time.
If we tell our customers that we will pull all salary data on their behalf :( and remove Salary Details Real Time from the report, we get a run time of 2 minutes in Worker Assignment and Person Seniority RT.