+ Start a Discussion
michaellmichaell 

DBAmp SF_Replicate performance

I've been seeing our performance with SF_Replicate when we try to replicate our Account table as being quite slow. Another (smaller) table worked fine with SF Replicate.

As a workaround for my immediate need, I set up and copied just the columns I need without using SF_Replicate, and that worked out ok. But I know I'll want more columns in the future copied locally from the Account table.

Are there any particular pieces of advice anyone has as far as best performance practices concerning SF_Replicate?

Thanks,
Michael Lee
forceAmp SupporforceAmp Suppor
Hi Michael,

This is not a particuliarly good week to do benchmarks with the Winter '06 shakedown happening. I have seen performance go up and down all week with some SF_Replicate jobs taking up to 10 times as long.

Let's see what next week brings and retry your SF_Replicate procs then. Most users report SF_Replicate speeds on the order of 8,000 to 12,000 records a minute depending on row size.

Thanks,

Bill
michaellmichaell
Makes sense to me.