title: What is the optimal batch size for teradata upload
body: <p>I am trying to find out what it the optimal batch size for teradata uploads.</p>
  
  <p>I read some article about the optimal batch size . <a href="http://developer.teradata.com/connectivity/articles/speed-up-your-jdbcodbc-applications" rel="nofollow">One</a> of them states that <code>To get top-notch performance, you need to use a batch size of roughly 50,000 to 100,000</code> rows</p>
  
  <p>However, i have seen people saying that their batch included up to a million of rows .</p>
  
  <hr>
  
  <p>The number of columns could differ and it could be a very heavy 100 rows and 1000 columns dataset . </p>
  
  <p>So , is there any optimal batch size in terms of Megabytes ? How many Megabytes are optimal</p>
  
  <p>So far in my application i am using 200 Megabytes of data set as a maximum batch regardless of how many rows it includes . But i am not sure about whether it is optimal . </p>