Hibernate version: 3.1
database: Oracle 9i
Hibernate Documentation:
Quote:
13.1. Batch inserts
When making new objects persistent, you must flush() and then clear() the session regularly, to control the size of the first-level cache.
An example shows flush/clear in batches of 20 inserts.
My question is
1. is it safe to flush/clear after every 50-100 rows? (regardless of the actual batch size)
2. should the value set for
hibernate.jdbc.batch_size always be used?
3. can the JDBC batch size be obtained at runtime if the
hibernate.jdbc.batch_size property is not configured?
Thank-you
Paul