Why hibernate is so slow, it take 28sec to get the same data, where i can get it from the raw sql withn 4sec;

This is my H mapping:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
<class name="com.w.core.wUser" table="W_USER" lazy="true">
<id name="id" type="long">
<generator class="native"/>
</id>
<property name="userName" type="string" not-null="true" unique="true"/>
<property name="password" type="binary" not-null="true"/>
<property name="name" type="string"/>
<property name="verificationQuestion" type="string"/>
<property name="verificationAnswer" type="string"/>
<many-to-one name="region" class="com.w.core.Region" lazy="true"/>
<many-to-one
name="sellerDetails"
class="com.w.core.wSellerDetails"
cascade="all"/>
<set name="offers" inverse="true"> <!--sort="com.w.core.wOfferDateComparator">-->
<key column="seller"/>
<one-to-many class="com.w.core.wOffer" lazy="true"/>
</set>
<set name="tenderOffers" inverse="true">
<key column="offerer"/>
<one-to-many class="com.w.core.TenderOffer" lazy="true"/>
</set>
<property name="isReseller" type="boolean">
<column name="isreseller"/>
</property>
<property name="resellerId" type="long">
<column name="reseller_id"/>
</property>
<property name="buyerApproved" type="boolean">
<column name="buyer_approved"/>
</property>
<property name="sms" type="boolean"/>
<property name="referrals" type="integer"/>
<property name="referal" type="string"/>
<property name="banned" type="boolean"/>
<property name="weeklyReport" type="calendar"/>
<property name="datePlaced" type="calendar">
<column name="dateplaced"/>
</property>
<many-to-one name="userType" class="com.w.core.wUserType" lazy="true">
<column name="usertype"/>
</many-to-one>
<property name="companyName" type="string">
<column name="company_name"/>
</property>
</class>
</hibernate-mapping>


Only has 751 raw of data in the table,
and this is the class i use;

result = sess.find("from com.w.core.wUser u "
+ " where u.resellerId = ? "
+ var
+ " order by u.name",
getId(), Hibernate.LONG);
logger.debug("sess.find took " + " : " + (System.currentTimeMillis() - start)/1000 + " seconds ");

and it take 24sec, i try it without order by, and only less by one second,

please give me some feed back to fix this issue;
im using version 2.0.3 of hibernate. on postsql sever :)

Put


in your hibernate.cfg.xml and/or use http://www.p6spy.com to get more information about what hibernate is doing.

If you see ans joins this means you should make sure this associations are loaded lazyly.

HTH
Ernst