Using our previous version I was able to insert 50,000 records in 26.93 minutes, that is 31 rows per second with this DTS, on this image. I felt that this would help me see the raw changes. No formatting of data, no lookups, just moving the data in from the table as fast as possible. Next I built a DTS to insert these into Dynamics CRM as Leads. I created a table in SQL and copied the CSV file into the SQL table. He has built many file sizes from 500 to 5 million contact names, perfect for our purposes. these are random names mixed with random addresses with properly formatted e-mail and web addresses. By the way if you are looking for some test data I found a great resource for generic contact lists. First I set up a SQL database with 50,000 contacts and built a simple DTS to insert these contacts into Microsoft Dynamics CRM 2011 as Leads. So below is the first step of the performance improvements. I just want to take it out and let her “stretch out her legs”, lets see how fast we could go. So over the holidays I upgraded some of my virtual machine images to see what kind of performance improvements one can make by upgrading Scribe along with several other sub systems. In December when this was released, I was so excited to see our focus was on speed. Prior to Insight Version 7.6, the Bulk Insert feature was set for the entire DTS file, rather than for each step. Now you can now set bulk operations for individual steps within a DTS file. For data stores that support bulk operations (such as Dynamics CRM and Salesforce), you can now configure DTS files to specify bulk processing with basic insert, update, and delete.
Scribe Insight’s newest release has added a Bulk Operation mode to improve the performance at which we send data into Dynamics CRM and Salesforce.Com.
0 kommentar(er)
