These records are being stored in a collection and they are not being bound
to a UI element. These records contain a column of type "text" that contains
XML data which will be parsed later on in the process.
Just now I have modified my code to work with smaller chunks of 500 records
at a time instead of the whole lot of 3000+ records. But it made no
difference in that after being done with a chunk of 500 records, the memory
usage did not reset or clear. Instead, it grew every time a new chuck of
records were being processed.
Any suggestions? Is there a way to explicity release the data in memory once
the code is done with it?
Thanks in advance.
"Nicholas Paldino [.NET/C# MVP]" <mv*@spam.guard.caspershouse.com> wrote in
message news:ua**************@TK2MSFTNGP09.phx.gbl...
RH,
I assume you are using a DataSet to store all of this data. Is it
really required to have all of that information in memory, or are you
processing all of that data and then just letting it go? I can't imagine
you binding a UI element to 3000 records.
What are you trying to do that you need all 3000 records in memory at
once?
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com
"RH" <rh******@cog.com> wrote in message
news:eb*************@tk2msftngp13.phx.gbl... Hi,
I am building a windows application that has a feature that retrieves a set of records when a button is clicked. When the records are being
retrieved I experience a complete system degradation, including other programs that
become unresponsive.
Here's what I found while the retrieval process is running:
Using the Windows Task Manager, I can see the the "Page File (PF) Usage"
indicator under the Performance tab increase in value from 360 MB to
over often over 1 GB when returning 3000-6000 records.
The "Mem Usage" indicator under the Processes tab increases from 40,000K
to over 300,000K.
When the operation is done, the memory usage levels remain the same and
the response time for my whole computer remains slow. Only until after the
application is closed does the memory usage levels go back down and my
computer returns to its normal response time.
Also, I'm not sure if this matters but the table that contains these
records has a column of type "text" which may contain data in the size of
100-5000 characters.
Any help on what is going on and suggestions on how to fix this would be
appreciated. Thanks!