SCC_SFP_LOAD AppEngine process takes a very long time to run
Summary:
SCC_SFP_LOAD AppEngine process takes a very long time to run
Content (please ensure you mask any confidential information):
UNLV is well into our first year with SFA/SFP, and we have discovered several of our processes take a long time to run. Specifically, the SCC_SFP_LOAD (which populates the SCC_SFP_R_% reporting tables) runs REALLY slow. This seems to be caused by the sheer number of rows that have to be inserted into the various SCC_SFP_R_% tables, as well as the calls that must be made back to SFA during the inserts.)
Has anyone else encountered this issue, and would you be willing to chat with us about it? Currently, SCC_SFP_LOAD rarely runs to completion, which worries us since that means our reporting tables will be incomplete.