具有大记录数据表的系统内存不足异常 [英] System Out Of Memory Exception with large records datatable

问题描述

我正在研究一个包含大量数据表的代码，每个数据表都有大量的记录--1500多个。它运行良好，直到几天后突然它开始抛出错误 -

Sytem内存超出异常。



有几个链接，我知道32位操作系统允许最大2GB的对象大小。我在一台4GB物理内存的机器上运行。





有人可以建议解决问题。这是非常紧急的！



谢谢，

Hi,

I am working on a code with lot of datatables, each having large number of records - 150000 plus. it was running fine till few days back and suddenly it started throwing error -
Sytem memory out of exception.

With a few links, i get to know that 32 bit OS allows max 2gb object size. I am running on a machine with 4GB physical memory.


Can somebody suggest anything to get it resolved. It's very urgent!

Thanks,

推荐答案

每个进程的内存限制不是你能克服的在32位系统上（无论你是否安装了4GB的ram）。



1）尝试在较小的数据块上进行处理。



2）转移到64位操作系统。

The memory limit per process is not something you can overcome on a 32bit system (no matter if you have 4gb of ram installed).

1) Try doing your process on smaller chunks of data.

2) Move to a 64bit OS.

这篇关于具有大记录数据表的系统内存不足异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！