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

Replication of Attachment object performance

Hello,
I am running SF_ReplicateAll scheduled as SQL server job during the night. It works fine for most of the tables except Attachment. Attachment is 35000 records total of 5.4 GB data size on the local SQL server. Replication of this table takes very long - the fastest time I have seen it was 9 hours. For comparison Acconut object contains 341768 records (1.3 GB) and takes about 30 minutes to replicate.
Is there any way to improve performance for Attachment object?
Thank you
1 person has
this question
+1
Reply
  • The salesforce api performs poorly when returning large binary blobs like attachments for multiple reasons (binary data must be encoded to fit inside the xml SOAP message, the batch size is usually reduced to 1 from 2000 per api call, etc.)

    The first question to ask is do you actually need the blob data downloaded to your SQL Server. Later versions of DBAmp have the ability to download the Attachment table without downloading the blob itself. For most customers, this is fine because the binary blob is not needed locally.

    If this would work for you, then post your currently installed version of DBAmp so we can plan an upgrade to the latest version.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • Thank you for this information. We can either use the new feature or exclude attachments from replication and only have them as refresh. I think there will not be too many attachments added daily so refresh may work fine and allow me to have blobs available on the local database.
    Thnak you
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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