Synchronize is slow

Dec 5, 2011 at 7:43 PM

Is there any way to speed up the synchronization porcess.  It seems to take 3 hours to sync a list with 10K items.

XML for list.

<List Site="Processes/Workflow" Name="MDM: Item Master Data" ActivationOrder="1">
 <Fields>
 <Field Name="Item Id" SqlType="varchar(255)" SPType="Text" Required="true"></Field>
 <Field Name="Item Description" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Master Item Id" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Completed" SqlType="datetime" SPType="Date and Time" Required="false"></Field>
 <Field Name="Source System" SPType="Lookup" AssociatedList="MDM: Source Systems" AssociationName="MDMGLUE_ItemMasterData_SourceSystem"></Field>
 <Field Name="Tax Element 1" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Tax Element 2" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Tax Element 3" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Tax Element 4" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Tax Element 5" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Parent Id" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Parent Source System" SPType="Lookup" AssociatedList="MDM: Source Systems" AssociationName="MDMGLUE_ItemMasterData_ParentSourceSystem"></Field>
 <Field Name="Family Source System" SPType="Lookup" AssociatedList="MDM: Source Systems" AssociationName="MDMGLUE_ItemMasterData_FamilySourceSystem"></Field>
 <Field Name="Tax Elem 5 Cd" SPType="Lookup" AssociatedList="MDM: Source System Taxonomy" AssociationName="MDMGLUE_ItemMasterData_SourceSystemTaxonomy"></Field>
 <Field Name="Phase" SPType="Lookup" AssociatedList="Lookup: Phases" AssociationName="MDMGLUE_ItemMasterData_Phases"></Field>
 <Field Name="Status" SqlType="varchar(255)" SPType="Choice" Required="false"></Field>
 <Field Name="Global Tax Ind" SqlType="int" SPType="Number" Required="false"></Field>
 <Field Name="Change Reason" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
 <Field Name="Equipment Number" SqlType="varchar(255)" SPType="Text" Required="false"></Field>
</Fields>

</List>

Thanks

Jerry

Developer
Dec 5, 2011 at 9:00 PM

Syncronization is really only intented to be used when initially setting up SLAM.  Once you've syncronized, there really should be no reason to need to sync again given that SLAM is keeping the database in sync in (near) real time.

Do you find yourself resyncing frequently?  If so, why?

Yours,

Allan

Dec 5, 2011 at 10:43 PM

We don’t resyncing often unless we add addition fields, but we have a list with 200K records and we haven’t been able to finish syncing at all because the sync runs so long something is bound to interrupt it.

I was thinking writing an SSIS job to sync the list and use SLAM for the real-time features.