A. The first factor is how the live rate matrix is set up. The more columns that are added to the matrix, the more time is needed to insert records into the rate table: NBI_PROJ_RES_RATES_AND_COSTS
Once the rates are available in this table, by way of the Rate Matrix Extraction job completion, the rates are then made available to the following actions:
-Running the Post Timesheets job
-Running the Update Earned Value Totals job (or clicking Project > Action > Update Cost Totals)
-Running the Update Earned Value History job
-Opening OWB or MSP
Therefore, timing is very important.
If changes are made to the live rate matrix, the rate changes will not be made until the RME job is ran.
B. The second set of factors that influence the runtime of the Rate Matrix Extraction (RME) job is the number of projects, resources, tasks that exist in the system.
As the number of projects increase, so does the number of resources assigned to tasks on the projects.
The following best practices can lower the job runtime, therefore forcing project managers to maintain projects:
1. Remove any rate matrices from Administration > Finance > Setup > Defaults > Project Transaction Entry Defaults
2. Remove any rate matrices from Administration > Finance > Setup > Entities that are no longer used
3. Deactivate investments.
a. Set financial status = HOLD.
b. Uncheck the active flag.
c. Remove the rate matrix that is set for each labor type
C. The third factor is whether or not the database maintenance is being performed by the DBA team.
Over time, database performance can suffer, causing one or more jobs to take longer to run due to a lack of maintenance. Once maintained, the performance can and will improve overall.