There are two table "policy" and "insurant";
The relation between them is following:
policy.hbm.xml
...............
<map name="insurants" table="Insurant" lazy="false"
sort="unsorted" cascade="all" order-by="id">

<key column="policy"></key>

<index column="id" type="java.lang.String" length="32" />

<one-to-many class="com.db.bo.Insurant" />

</map>
...................
when I search policy in JSP,it is very slow. I found a greate number of sql in console
............
Hibernate:select .... from insurant where policy=?
Hibernate:select .... from insurant where policy=?
Hibernate:select .... from insurant where policy=?
............

I used JSP taglib <nested:iterate id="policy" name="policyList"> when search policy information.

Who can help optimize search efficiency???