title: What is the difference between hibernate.jdbc.fetch_size and hibernate.jdbc.batch_size?
body: <p>I am trying to tune my application, came across some blogs speaking about the batch fetch and batch select and putting my understanding as follows.</p>
  
  <ul>
  <li><code>hibernate.jdbc.fetch_size</code> - Used to specify number of rows to be fetched in a select query.</li>
  <li><code>hibernate.jdbc.batch_size</code> - Used to specify number of inserts or updates to be carried out in a single database hit. </li>
  </ul>
  
  <p>Please let me know whether my understanding is correct or not? Also what are the <em>optimal values</em> for the above parameters..</p>