title: Truncate with Hibernate and H2 is slower than expected
body: <p>Using Hibernate 4.3.11 and H2 1.3.172 database</p>
  
  <p>I changed code to use truncate to empty a database table rather than delete because delete was performing too slowly as the number of records in the table increased. However <em>TRUNCATE</em> also seems rather slow (aprox 30 seconds) I assumed it would work rather quickly and would not matter how many records were in the table ?</p>
  
  <pre><code>    try
      {
          session = HibernateUtil.beginTransaction();
          session.createSQLQuery("truncate table SongDiff").executeUpdate();
          session.getTransaction().commit();
          return true;
      }
      catch(Exception ex)
      {
          MainWindow.logger.log(Level.SEVERE, ex.getMessage(), ex);
      }
      finally
      {
          HibernateUtil.closeSession(session);
      }
  </code></pre>