none
50K+ Items in List RRS feed

  • Question

  • Scenario:

    I have 50,000+ items in my list. and i took 2 approaches to download the same to my local database. first i developed a console app which iterate through all of the records and download the same to my local database. to do this it took almost 2 days time to complete. As i was using REST API to iterate and download the records.

    then i developed SSIS package with OData Add in to download the list items. and same task completed in an hour. 

    My Question is how come SSIS + REST can download the full data and while Console + REST API could not load full data in one go.

    Request a suggestion on the same.Thanks in advance.


    Thanks, Parth

    Thursday, March 9, 2017 2:43 AM

Answers

  • IT SEEMS THERE IS NO ANSWER AVAILABLE TO KNOW WHAT MAKES SSIS SO FAST THAN REST API APPROACH IN C#


    Thanks, Parth

    • Marked as answer by Parth Rawal Saturday, March 11, 2017 8:29 AM
    Saturday, March 11, 2017 8:29 AM

All replies