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

When to Refresh or Replicate

At what point does it become more advantageous to replicate a table or refresh it.

I have a table that I know is getting 30% to 100% of the record update. 10m record house file.

At what point is Replication of the table going to outperform a refresh? If at all.

Is there a point where replication makes sense based on the simple volume of updates. 100k, 500k , 1m, 5m...
1 person has
this question
+1
Reply
  • Normally, if there are that many records being updated in between SF_Refresh runs, then SF_Replicate would be more advantageous. SF_Refresh is built for incremental updates when some records change, so maybe up to ~50,000 records. For 30-100% of a 10 million row table, SF_Replicate would definitely be faster.

    Make sure you are using the bulkapi or pkchunk for replicates above 300,000 records or so. What version of DBAmp are you currently running?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. happy, confident, thankful, excited sad, anxious, confused, frustrated kidding, amused, unsure, silly indifferent, undecided, unconcerned