Hibernate 之 Hibernate.initialize(Obj)方法 ---减少数据查询时间

最新推荐文章于 2021-11-02 04:45:00 发布

awtqty_zhang

最新推荐文章于 2021-11-02 04:45:00 发布

阅读量172

点赞数

分类专栏： hibernate 文章标签： java

本文链接：https://blog.csdn.net/awtqty_zhang/article/details/84428737

版权

hibernate 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在当前项目中遇到一个问题，在查询列表时很慢，通过查找，发现在数据查询时耗费太多时间，因为在查询语句中存在left join fetch，需要的关联查询太多，这样查询时，疑Hibernate是将所有数据查询到内存中后，再进行分页的（这就是网上所讲的fetch产生的假分页问题），所以比较慢，后使用 Hibernate.initialize(Obj.getXxx())方法后解决该问题。

修改前查询列表功能代码如下：

@SuppressWarnings ( "unchecked" )

public List<TCustomer> findList( boolean status, TUser user, String name, String code, String ledger, int pageNo, int pageSize)

throws Exception {

StringBuffer sb = new StringBuffer ();

HashMap<String, Object> map = new HashMap<String, Object>();

sb.append( "select distinct customer from TCustomer as customer left join fetch customer.TCustomerLedgers" );

if (status) {

sb.append( " where customer.id in( select uc.TCustomer.id from TReUserCustomer as uc where uc.TUser =:user) " );

} else {

sb.append( " where customer.id not in( select uc.TCustomer.id from TReUserCustomer as uc where uc.TUser =:user) " );

}

map.put( "user" , user);

converQuerySQL(sb, name, code, ledger, map);

Session session = this .getSession();

Query query = session.createQuery(sb.toString());

this .setQueryParaments(query, map);

if (pageNo != WebSiteDictionary. D_PAGENO && pageSize != WebSiteDictionary. D_PAGESIZE ) {

query.setFirstResult(pageSize * (pageNo - 1));

query.setMaxResults(pageSize);

}

List<TCustomer> list = query.list();

releaseSession(session);

return list;

}

修改前测试时打印SQL如下：

Hibernate: select distinct tcustomer0_.id as id35_0_, tcustomerl1_.id as id45_1_, tcustomer0_.customerTypeId as customer2_35_0_, tcustomer0_.customerCode as customer3_35_0_, tcustomer0_.status as status35_0_, tcustomer0_.parentCustomerId as parentCu5_35_0_, tcustomer0_.source as source35_0_, tcustomer0_.fullName as fullName35_0_, tcustomer0_.shortName as shortName35_0_, tcustomer0_.logo as logo35_0_, tcustomer0_.updateTime as updateTime35_0_, tcustomer0_.customerCompanyId as custome11_35_0_, tcustomerl1_.customerId as customerId45_1_, tcustomerl1_.ledger as ledger45_1_, tcustomerl1_.payConditionId as payCondi4_45_1_, tcustomerl1_.credit as credit45_1_, tcustomerl1_.currencyId as currencyId45_1_, tcustomerl1_.shippingTypeId as shipping7_45_1_, tcustomerl1_.personId as personId45_1_, tcustomerl1_.postCode as postCode45_1_, tcustomerl1_.fax as fax45_1_, tcustomerl1_.companyPhone as company11_45_1_, tcustomerl1_.bank as bank45_1_, tcustomerl1_.bankAccount as bankAcc13_45_1_, tcustomerl1_.contactPerson as contact14_45_1_, tcustomerl1_.createUserId as createU15_45_1_, tcustomerl1_.createDate as createDate45_1_, tcustomerl1_.isDelete as isDelete45_1_, tcustomerl1_.customerCode as custome18_45_1_, tcustomerl1_.saleProtocal as salePro19_45_1_, tcustomerl1_.customerId as customerId35_0__, tcustomerl1_.id as id0__ from dbo.T_Customer tcustomer0_ left outer join dbo.T_CustomerLedger tcustomerl1_ on tcustomer0_.id=tcustomerl1_.customerId and ( tcustomerl1_.isDelete is null or tcustomerl1_.isDelete = 0) where tcustomer0_.id not in (select treusercus2_.customerId from dbo.T_ReUserCustomer treusercus2_ where treusercus2_.userId=?)

注：在这个SQL中不存在top关键字。

修改前查询所需时间：24651毫秒

----------------------------------------------

修改后查询列表功能代码如下：