> I'm trying to return a DataTable with 146k rows * 41 columns.
> Returning smaller sets works but the larger ones throw this exception.
> I saw there was a bug in 1.0 sp 1 &2 but I thought it was fixed by
> now. Are there any suggestions on what could be the cause?
>
> The remoting object is being hosted by IIS and the machine has 2 gigs
> of physical ram. w3wp.exe shows a max usage of 503 megs of ram.
>

"Alexander Shirshov" <alexander@omnitalented.com> wrote in message
news:26410632451810181276448@news.microsoft.com...
> Joe,
>
> Can you save the DataSet to a file using WriteXml and tell us its size?
>
> Sorry, I don't have the answer but can suggest what might be a workaround.
> DataSet always serilaizes to XML. If values you return are small the
overhead
> XML verbosity imposes can be enormous. You could try to do your own
serialization.
>
>
> Alexander
>
> > I'm trying to return a DataTable with 146k rows * 41 columns.
> > Returning smaller sets works but the larger ones throw this exception.
> > I saw there was a bug in 1.0 sp 1 &2 but I thought it was fixed by
> > now. Are there any suggestions on what could be the cause?
> >
> > The remoting object is being hosted by IIS and the machine has 2 gigs
> > of physical ram. w3wp.exe shows a max usage of 503 megs of ram.
> >
>
>
>