Re: DataSet Memory Usage

From: W.G. Ryan eMVP (WilliamRyan_at_NoSpam.gmail.com)
Date: 11/30/04 

Date: Mon, 29 Nov 2004 23:50:12 -0500

Um, it's a little late so I can't do the math, but off of the top of my
head, those numbers looks approx correct. Remember all of that data is
getting cached locally - so that sounds right. The easy way is to check w/
a trace and see what the Ram being used before you call Fill is, and then
afterward. 

-- 
W.G. Ryan MVP (Windows Embedded)
TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
<howard39@nospam.nospam> wrote in message
news:4303A495-9288-44C3-A30C-FB75160A2011@microsoft.com...
> I'm working with a large ADO.Net DataSet and my application uses quite a
bit
> of memory.
>
> According to the memory profiler I am using, there are about 120,000
> DataRows, and they take up about 5 Megabytes. These DataRows are contained
in
> a total of about 70 tables. However in addition there are about 8,000
int32[]
> array objects that all together take up about 50 Megabytes. I think that
most
> of these are instantiated from within the System.Data namespace.
>
> My application inserts, deletes or modifies about 10 percent of the
> DataRows. It also uses DataViews and sorting.
>
> Is this a known problem of some kind?
>