C# API calls against Azure Cloud taking a long time

Erik Olson

Good Morning, we are attempting to load a .csv file to our production Azure Cloud instance of BBCRM and while it does successfully complete the load, it take an extremely long time to process a file of 12,000 lines of data against production (think 20 hours).  Against a local dev environment, 6,000 line took about 2.5 hours, which seems reasonable enough but I am not going out over the web since the dev box is self contained with its own instance of the database and its own IIS.  Has anyone else experienced this kind of slow down in their production environments doing API calls to load in data?  If so, were you able to get around it somehow?  We are already using a form of task threading to call methods down different threads to attempt to speed things up.