Help get this topic noticed by sharing it on Twitter, Facebook, or email.

sf_refresh speed slowing over time2

sf_refresh seems very slow...it used to complete this in < 30 seconds...
this run took 4 minutes and 29 seconds...
i've included the results and the linked server settings

--- Starting SF_Refresh for task V3.6.6
10:11:38: Using Schema Error Action of yes
10:12:07: Using last run time of 2019-01-07 06:36:00
10:12:26: Identified 124 updated/inserted rows.
10:12:28: Identified 0 deleted rows.
10:12:28: Adding updated/inserted rows into task
--- Ending SF_Refresh. Operation successful.
--- Starting SF_Refresh for account V3.6.6
10:12:28: Using Schema Error Action of yes
10:12:51: Using last run time of 2019-01-07 06:37:00
10:13:10: Identified 29 updated/inserted rows.
10:13:12: Identified 0 deleted rows.
10:13:12: Adding updated/inserted rows into account
--- Ending SF_Refresh. Operation successful.
--- Starting SF_Refresh for contact V3.6.6
10:13:12: Using Schema Error Action of yes
10:13:36: Using last run time of 2019-01-07 06:37:00
10:13:55: Identified 29 updated/inserted rows.
10:13:57: Identified 0 deleted rows.
10:13:57: Adding updated/inserted rows into contact
--- Ending SF_Refresh. Operation successful.
--- Starting SF_Refresh for user V3.6.6
10:13:58: Using Schema Error Action of yes
10:14:20: Using last run time of 2019-01-07 06:38:00
10:14:39: Identified 0 updated/inserted rows.
10:14:40: Identified 0 deleted rows.
--- Ending SF_Refresh. Operation successful.
--- Starting SF_Refresh for casecomment V3.6.6
10:14:40: Using Schema Error Action of yes
10:15:03: Using last run time of 2019-01-07 06:39:00
10:15:23: Identified 10 updated/inserted rows.
10:15:24: Identified 0 deleted rows.
10:15:24: Adding updated/inserted rows into casecomment
--- Ending SF_Refresh. Operation successful.
--- Starting SF_Refresh for case V3.6.6
10:15:24: Using Schema Error Action of yes
10:15:47: Using last run time of 2019-01-07 09:31:00
10:16:07: Identified 1 updated/inserted rows.
10:16:08: Identified 0 deleted rows.
10:16:08: Adding updated/inserted rows into case

1 person has
this problem
+1
Reply