OutOfMemoryExce ption on DataTables

[Venkatachalam]

Hi,
In my application I have text(flat) file as input and I have to generate
an XML file. The maximum input text file size can be 900MB and gererated xml
may result 2+ GB.

Based on the first column value from the text file, the row will be moved to
any of those 23 DataTable which are created onfly.

For eg.
01;- data for Table 1-
02;- data for Table 2-
03;- data for Table 3-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-

Based on the child relation, I have to create XML node, after stripping the
parent-child relation column.

I am using XmlTextWriter to write the xml data, which are fetched from
tables based on select with different condition.

The server uses 2GB RAM memory

When the application process a 500MB file, it throws OutOfMemoryExce ption.
In the task manager, the utilised memory when the system throws
OutOfMemoryExce ption is 2.15 GB.

But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExce ption issues.

Can you one help me in this regard.

Thanks in advance

With Regards
venkatg

[Jon Skeet [C# MVP]]

Venkatachalam <Ve***********@ discussions.mic rosoft.com> wrote:

In my application I have text(flat) file as input and I have to generate
an XML file. The maximum input text file size can be 900MB and gererated xml
may result 2+ GB.
Do you really need to hold all of that in memory at the same time? It
sounds like it would be much more likely to work if you could process
the file writing out data as you went, even if you need to process the
input file a few times.

<snip>
When the application process a 500MB file, it throws OutOfMemoryExce ption.
In the task manager, the utilised memory when the system throws
OutOfMemoryExce ption is 2.15 GB.
I believe that without some extra support (which I don't know the
details of) a single process can't go above 2GB.
But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExce ption issues.

Can you one help me in this regard.

That's your desktop swapping memory out to disk. Note that when this
happens, anything which tries to use that virtual memory will slow down
hugely.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Sheva]

Probably your home computer has virtual memory enabled, and its size is
allocated to something more than 512 MB, but your server computer doesn't.
Anyway, when you process a large quantity of data, you should not use
DataSet or DataTable or sorta things like that, because those data objects
will preload all the data into memory. you should use some cursor based
forward only Reader classes to read and process the data on demand.

Sheva
"Venkatacha lam" <Ve***********@ discussions.mic rosoft.com> wrote in message
news:81******** *************** ***********@mic rosoft.com...

Hi,
In my application I have text(flat) file as input and I have to generate
an XML file. The maximum input text file size can be 900MB and gererated
xml
may result 2+ GB.

Based on the first column value from the text file, the row will be moved
to
any of those 23 DataTable which are created onfly.

For eg.
01;- data for Table 1-
02;- data for Table 2-
03;- data for Table 3-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-

Based on the child relation, I have to create XML node, after stripping
the
parent-child relation column.

I am using XmlTextWriter to write the xml data, which are fetched from
tables based on select with different condition.

The server uses 2GB RAM memory

When the application process a 500MB file, it throws OutOfMemoryExce ption.
In the task manager, the utilised memory when the system throws
OutOfMemoryExce ption is 2.15 GB.

But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExce ption issues.

Can you one help me in this regard.

Thanks in advance

With Regards
venkatg

[Venkatachalam]

All the data has to be in the momory, as there are very complex relation
involved among the tables.

If I split the file to read, then the performance will go ver very worst.

And also the server has 4 Intel Xeon CPU 3.00GHz processor.

With regards
Venkat

"Jon Skeet [C# MVP]" wrote:

Venkatachalam <Ve***********@ discussions.mic rosoft.com> wrote:

In my application I have text(flat) file as input and I have to generate
an XML file. The maximum input text file size can be 900MB and gererated xml
may result 2+ GB.

Do you really need to hold all of that in memory at the same time? It
sounds like it would be much more likely to work if you could process
the file writing out data as you went, even if you need to process the
input file a few times.

<snip>

When the application process a 500MB file, it throws OutOfMemoryExce ption.
In the task manager, the utilised memory when the system throws
OutOfMemoryExce ption is 2.15 GB.

I believe that without some extra support (which I don't know the
details of) a single process can't go above 2GB.

But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExce ption issues.

Can you one help me in this regard.

That's your desktop swapping memory out to disk. Note that when this
happens, anything which tries to use that virtual memory will slow down
hugely.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Jon Skeet [C# MVP]]

Venkatachalam <Ve***********@ discussions.mic rosoft.com> wrote:

All the data has to be in the momory, as there are very complex relation
involved among the tables.
Well, even so I'd consider trying to work out a way of dealing with it
without having all of it in memory at a time.
If I split the file to read, then the performance will go ver very worst.

And also the server has 4 Intel Xeon CPU 3.00GHz processor.

The speed of the processors (nor the fact that it's got four of them)
isn't terribly relevant. If you cause the server to start swapping,
performance will be *awful*.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Willy Denoyette [MVP]]

"Very worse", compared to what? your program can never run to an end on a 32
bit system where you only have access to 2GB of user space per process.
The free user space on a 32Bit system after the CLR, framework code and data
has been loaded is less than 1.8GB, so you memory requirements exceed
largely the available memory. Note that your data requirements will double
when converting the text file 'byte' oriented data into XML 'string'
oriented data, add to that the XML overhead and you will understand that you
simply can't hold all this data in memory on a 32 bit system.
So your options are:
- Split the input file into smaller portions, or
- Store the input data in a relational database, or
- Move to a 64 bit OS and add another 2GB of RAM.

Willy.

"Venkatacha lam" <Ve***********@ discussions.mic rosoft.com> wrote in message
news:EB******** *************** ***********@mic rosoft.com...
| All the data has to be in the momory, as there are very complex relation
| involved among the tables.
|
| If I split the file to read, then the performance will go ver very worst.
|
| And also the server has 4 Intel Xeon CPU 3.00GHz processor.
|
| With regards
| Venkat
|
| "Jon Skeet [C# MVP]" wrote:
|
| > Venkatachalam <Ve***********@ discussions.mic rosoft.com> wrote:
| > > In my application I have text(flat) file as input and I have to
generate
| > > an XML file. The maximum input text file size can be 900MB and
gererated xml
| > > may result 2+ GB.
| >
| > Do you really need to hold all of that in memory at the same time? It
| > sounds like it would be much more likely to work if you could process
| > the file writing out data as you went, even if you need to process the
| > input file a few times.
| >
| > <snip>
| >
| > > When the application process a 500MB file, it throws
OutOfMemoryExce ption.
| > > In the task manager, the utilised memory when the system throws
| > > OutOfMemoryExce ption is 2.15 GB.
| >
| > I believe that without some extra support (which I don't know the
| > details of) a single process can't go above 2GB.
| >
| > > But in my desktop, for the surprise, the system has 512 MB and when I
load
| > > several application, the process memory reached 1GB without any
| > > OutOfMemoryExce ption issues.
| > >
| > > Can you one help me in this regard.
| >
| > That's your desktop swapping memory out to disk. Note that when this
| > happens, anything which tries to use that virtual memory will slow down
| > hugely.
| >
| > --
| > Jon Skeet - <sk***@pobox.co m>
| > http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
| > If replying to the group, please do not mail me too
| >

[Lee]

Venkatachalam enlightened me by writing:

All the data has to be in the momory, as there are very complex
relation involved among the tables.

If I split the file to read, then the performance will go ver very
worst.

And also the server has 4 Intel Xeon CPU 3.00GHz processor.

With regards
Venkat

Venkat, couldn't you use an embedded database to do this operation?
Maybe FirebirdSQL Embedded or something? This way you could still keep
your entity relatioships intact?
--
Warm Regards,
Lee

"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

[Cor Ligthert [MVP]]

Venkatachalam,

Did you look at the virtual memory settings of both computers?

Just my first thought,

Cor

"Venkatacha lam" <Ve***********@ discussions.mic rosoft.com> schreef in bericht
news:81******** *************** ***********@mic rosoft.com...

Hi,
In my application I have text(flat) file as input and I have to generate
an XML file. The maximum input text file size can be 900MB and gererated
xml
may result 2+ GB.

Based on the first column value from the text file, the row will be moved
to
any of those 23 DataTable which are created onfly.

For eg.
01;- data for Table 1-
02;- data for Table 2-
03;- data for Table 3-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-
04;- data for Table 4-

Based on the child relation, I have to create XML node, after stripping
the
parent-child relation column.

I am using XmlTextWriter to write the xml data, which are fetched from
tables based on select with different condition.

The server uses 2GB RAM memory

When the application process a 500MB file, it throws OutOfMemoryExce ption.
In the task manager, the utilised memory when the system throws
OutOfMemoryExce ption is 2.15 GB.

But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExce ption issues.

Can you one help me in this regard.

Thanks in advance

With Regards
venkatg

[Willy Denoyette [MVP]]

VM is a non issue here the OP has 2GB of physical memory, so the VM is at
least 2GB and probably > 4GB. The problem is that the max. user address
space is 2GB (or 3GB with 4GT Ram tuning) on 32 bit windows.
Willy.

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:e%******** *******@TK2MSFT NGP14.phx.gbl.. .
| Venkatachalam,
|
| Did you look at the virtual memory settings of both computers?
|
| Just my first thought,
|
| Cor
|
| "Venkatacha lam" <Ve***********@ discussions.mic rosoft.com> schreef in
bericht
| news:81******** *************** ***********@mic rosoft.com...
| > Hi,
| > In my application I have text(flat) file as input and I have to
generate
| > an XML file. The maximum input text file size can be 900MB and gererated
| > xml
| > may result 2+ GB.
| >
| > Based on the first column value from the text file, the row will be
moved
| > to
| > any of those 23 DataTable which are created onfly.
| >
| > For eg.
| > 01;- data for Table 1-
| > 02;- data for Table 2-
| > 03;- data for Table 3-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| >
| > Based on the child relation, I have to create XML node, after stripping
| > the
| > parent-child relation column.
| >
| > I am using XmlTextWriter to write the xml data, which are fetched from
| > tables based on select with different condition.
| >
| > The server uses 2GB RAM memory
| >
| > When the application process a 500MB file, it throws
OutOfMemoryExce ption.
| > In the task manager, the utilised memory when the system throws
| > OutOfMemoryExce ption is 2.15 GB.
| >
| > But in my desktop, for the surprise, the system has 512 MB and when I
load
| > several application, the process memory reached 1GB without any
| > OutOfMemoryExce ption issues.
| >
| > Can you one help me in this regard.
| >
| > Thanks in advance
| >
| > With Regards
| > venkatg
|
|

[Cor Ligthert [MVP]]

Willy,

The difference between the laptop and the other computer was triggering me
in this.
What other reason can there been than just a setting of something like this.

But in my desktop, for the surprise, the system has 512 MB and when I load
several application, the process memory reached 1GB without any
OutOfMemoryExc eption issues.
I am not sure if he is doing the same application, probably not,

However as I wrote, it was only a thought,

Cor

"Willy Denoyette [MVP]" <wi************ *@telenet.be> schreef in bericht
news:O7******** *****@TK2MSFTNG P15.phx.gbl... VM is a non issue here the OP has 2GB of physical memory, so the VM is at
least 2GB and probably > 4GB. The problem is that the max. user address
space is 2GB (or 3GB with 4GT Ram tuning) on 32 bit windows.
Willy.

"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:e%******** *******@TK2MSFT NGP14.phx.gbl.. .
| Venkatachalam,
|
| Did you look at the virtual memory settings of both computers?
|
| Just my first thought,
|
| Cor
|
| "Venkatacha lam" <Ve***********@ discussions.mic rosoft.com> schreef in
bericht
| news:81******** *************** ***********@mic rosoft.com...
| > Hi,
| > In my application I have text(flat) file as input and I have to
generate
| > an XML file. The maximum input text file size can be 900MB and
gererated
| > xml
| > may result 2+ GB.
| >
| > Based on the first column value from the text file, the row will be
moved
| > to
| > any of those 23 DataTable which are created onfly.
| >
| > For eg.
| > 01;- data for Table 1-
| > 02;- data for Table 2-
| > 03;- data for Table 3-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| > 04;- data for Table 4-
| >
| > Based on the child relation, I have to create XML node, after
stripping
| > the
| > parent-child relation column.
| >
| > I am using XmlTextWriter to write the xml data, which are fetched from
| > tables based on select with different condition.
| >
| > The server uses 2GB RAM memory
| >
| > When the application process a 500MB file, it throws
OutOfMemoryExce ption.
| > In the task manager, the utilised memory when the system throws
| > OutOfMemoryExce ption is 2.15 GB.
| >
| > But in my desktop, for the surprise, the system has 512 MB and when I
load
| > several application, the process memory reached 1GB without any
| > OutOfMemoryExce ption issues.
| >
| > Can you one help me in this regard.
| >
| > Thanks in advance
| >
| > With Regards
| > venkatg
|
|