ResultSet限制 [英] ResultSet limit

问题描述

这是vinod。


i试图从数据库中读取10个缺少列数为14的记录单次。但我的应用程序显示OUT OF MEMORY错误。


任何帮助？


我的ID：< id已删除每个发布指南>


谢谢，

Vinod

Hi,

This is vinod.

i have tried to read a 10 lacks records with column count 14 from the database at a single time. But my application shows OUT OF MEMORY error.

Any help?

my id : <id removed per posting guidelines>

Thanks,
Vinod

推荐答案

这是vinod。


i一次尝试从数据库中读取10个缺少列数为14的记录。但是我的应用程序显示OUT OF MEMORY错误。


任何帮助？


我的ID：< id根据发布指南删除>


谢谢，

Vinod

Hi,

This is vinod.

i have tried to read a 10 lacks records with column count 14 from the database at a single time. But my application shows OUT OF MEMORY error.

Any help?

my id : <id removed as per posting guidelines>

Thanks,
Vinod

'10缺少'多少钱？


亲切的问候，


Jos

How much is ''a 10 lacks''?

kind regards,

Jos

10,00,000



谢谢，

vinod

10,00,000


Thanks,
vinod

10,00,000



谢谢，

vinod

10,00,000


Thanks,
vinod

所以这是一百万条记录，每条记录有14列？它取决于列的长度

，但我可以看到你得到一个OutOfMemoryError ...有一个

少数-X标志可以增加JVM'的堆大小，但我认为这只是推迟了执行的b $ b。你想什么一次在内存中加载那么多记录？


亲切的问候，


Jos

So that''s one million records with 14 columns each? It depends a bit on the length
of the columns but I can see that you get an OutOfMemoryError ... there are a
few -X flags that increase the JVM''s heap size but I think that''s just postponing
the execution. What do you want to load that many records in memory at once?

kind regards,

Jos

这篇关于ResultSet限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！