title: Should I commit after each SQL action, or do multiple actions and then commit? Which is more efficient?
body: <p>I need some clarification on the SQL scenario of SQL commits.</p>
  
  <p>FOr example: </p>
  
  <pre><code>    1)  DELETE FROM tablename WHERE column_name = 'value';
          COMMIT the above transaction;
  
      Versus
  
      2) 
           for (i...n){
              DELETE FROM tablename WHERE column_name ('value');
           }
  
           COMMIT after 'N' transactions..
  </code></pre>
  
  <p>Consider N >=10, In this case would the stress on the DB will be better compared to the 1st approach or would the 2nd approach will have the same effect as the 1st approach...
  I know the best approach is pass multiple values IN clause... Just need to know if 2nd is better than the 1st one>?</p>