1. 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
2. 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:
a. Remove any rate matrices from Admin > Finance > Setup > Defaults > Project Transaction Entry Defaults
b. Remove any rate matrices from Admin > Finance > Setup > Entities, that are no longer used
c. Remove matrices from inactive investments
d. Deactivate and close out projects that are no longer relevant.
3. 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.