title: how to load data faster with talend and sql server
body: <p>I use Talend to load data into a sql-server database.</p>
  
  <p>It appears that the weakest point of my job is not the dataprocessing, but the effective load in my database, which is not faster than 17 rows/sec.</p>
  
  <p>The funny point is that I can launch 5 jobs in the same time, and they'll all load at 17rows/sec .</p>
  
  <p>What could explain this slowness and how could I improve the speed?</p>
  
  <p>Thanks</p>
  
  <p><strong><em>New informations:</em></strong></p>
  
  <p>The transfer speed between my desktop and the server is about 1MByte</p>
  
  <p>My job commits every 10 000</p>
  
  <p>I use sql server 2008 R2</p>
  
  <p>And the schema I use for my jobs is like this:</p>
  
  <p><img src="https://i.stack.imgur.com/QyLtH.jpg" alt="enter image description here"></p>