We're using Firebird with the jaybird JDBC driver and Hibernate 3.
 
I'm currently working on the performance of our INSERTs.
 
- I've made our DAO.save() method call session.clear() every 50 calls to save(), and that helped performance.
 
- I've tried setting hibernate.jdbc.batch_size and hibernate.order_inserts and seen hibernate seem to be batching the inserts but saw no increase in performance.
 
- I changed to using one of the new id generators that pools and saw it getting 50 ids per select call but didn't see an increase in performance.
 
- I'm trying calling persist() instead of save() right now but so far no improvement.
 
Am I overlooking anything else in Hibernate?
 
Are there settings in the driver or Firebird that I need to set so that the batching has more effect?  We have very few indices.
 
Thanks,
Jeff Roberts




[Non-text portions of this message have been removed]