Hibernate version: 2.1.7c

<set name="Singlet_DHCPPool_M12na" lazy="true" inverse="true" cascade="all-delete-orphan" batch-size="6">
<key>
<column name="neEir" />
</key>
<one-to-many class="org.astri.ims.mne.m12na.singlet.dataobject.Singlet_DHCPPool_M12na" />
</set>
<set name="Singlet_NATTcp_M12na" lazy="true" inverse="true" cascade="all-delete-orphan" batch-size="6">
<key>
<column name="neEir" />
</key>
<one-to-many class="org.astri.ims.mne.m12na.singlet.dataobject.Singlet_NATTcp_M12na" />
</set>
<set name="Singlet_NATUdp_M12na" lazy="true" inverse="true" cascade="all-delete-orphan" batch-size="6">
<key>
<column name="neEir" />
</key>
<one-to-many class="org.astri.ims.mne.m12na.singlet.dataobject.Singlet_NATUdp_M12na" />
</set>
<set name="Singlet_ApRadio_M12na" lazy="true" inverse="true" cascade="all-delete-orphan" batch-size="6">
<key>
<column name="neEir" />
</key>
<one-to-many class="org.astri.ims.mne.m12na.singlet.dataobject.Singlet_ApRadio_M12na" />
</set>



MySQL 4.0.12

There are some configurable parameters for hibernate. I would like to get more understanding how they are related and how to tune the best value
jdbc_batch_size
its recommended value is 5-30. when it is 0, it means disable the jdbc batch.
fetch_batch_size
by default, it is disable
In the document , i can specify batch fetching (and its size) in the class definition or set definiton of the collection. so how is it related to the fetch_batch_size? is it the fetch_batch_size the global setting of all collection ? (for both immediate and lazy initialization) or it means other things?

any hints I can tune these parameters (for batch fetching in collection, i think setting it to the no. of objects in the collection that it would usually be retrieved with the parent object is a good choice, just dunno how it's related to fetch_batch_size and jdbc_batch_size