138万条记录的List()与iterate()速度对比

最新推荐文章于 2025-08-08 22:01:10 发布

最新推荐文章于 2025-08-08 22:01:10 发布 · 111 阅读

文章标签：

#java

java 专栏收录该内容

27 篇文章

订阅专栏

本文介绍使用Hibernate进行数据库分页查询的几种方法，包括使用list()和iterate()的区别，以及如何通过设置firstResult和maxResults参数实现高效的数据分页加载。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

程序代码

        Session session=HibernateSessionFactory.getSession();
        List li=null;
        Date d=new Date();
        System.out.print(d.toString());
        li=session.createQuery("from TgovMaterial").list();
        Date d2=new Date();
        System.out.print(d2.toString());

...超出内存...

程序代码

Wed Jun 04 09:31:43 GMT 2008Hibernate: select tgovmateri0_.Id as col_0_0_ from [Material-08].dbo.tGovMaterial tgovmateri0_
Wed Jun 04 09:31:43 GMT 2008
不到一秒钟,所以记录较多时,我们推荐使用iterate()
输出测试:

程序代码

        Session session=HibernateSessionFactory.getSession();
        Iterator it=null;
        Date d=new Date();
        System.out.print(d.toString());
        it=session.createQuery("from TgovMaterial").iterate();
        while(it.hasNext())
        {
            TgovMaterial t=(TgovMaterial)it.next();
            System.out.println(t.getId());
        }
        Date d2=new Date();
        System.out.print(d2.toString());

Wed Jun 04 09:38:17 GMT 2008
.......
Wed Jun 04 09:39:20 GMT 2008

竟然只有一分来钟

程序代码

it=session.createQuery("from TgovMaterial").setFirstResult(1).setMaxResults(50).iterate();

Wed Jun 04 09:41:43 GMT 2008Hibernate: select top 51 tgovmateri0_.Id as col_0_0_ from [Material-08].dbo.tGovMaterial tgovmateri0_
....
Wed Jun 04 09:41:43 GMT 2008

不到1秒

程序代码

it=session.createQuery("from TgovMaterial").setFirstResult(1000000).setMaxResults(60).iterate();

Wed Jun 04 09:53:15 GMT 2008Hibernate: select top 1000060 tgovmateri0_.Id as col_0_0_ from [Material-08].dbo.tGovMaterial tgovmateri0_
....
Wed Jun 04 09:53:18 GMT 2008

程序代码

it=session.createQuery("from TgovMaterial").setFirstResult(1300000).setMaxResults(60).iterate();

Wed Jun 04 09:55:09 GMT 2008Hibernate: select top 1300060 tgovmateri0_.Id as col_0_0_ from [Material-08].dbo.tGovMaterial tgovmateri0_
...
Wed Jun 04 09:55:13 GMT 2008

程序代码

it=session.createQuery("from TgovMaterial").setFirstResult(10000).setMaxResults(60).iterate();

Wed Jun 04 09:55:53 GMT 2008Hibernate: select top 10060 tgovmateri0_.Id as col_0_0_ from [Material-08].dbo.tGovMaterial tgovmateri0_