Serviced Component Throws OutOfMemoryException

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arjuna Marambe - 02 Dec 2005 14:56 GMT

Hi,

When I try to load around 17,000 records into a DataSet and return it
through a Serviced Component I get the following message from the runtime.

Exception of type System.OutOfMemoryException was thrown.

Does anyone know what I can do to avoid this.

Reply to this Message

Klaus H. Probst - 09 Dec 2005 03:05 GMT

Don't pass so many records. Seriously, the dataset is a big memory hog
because it's essentially an in-memory database. The problem here is that if
your COM+ application is server-activated (instead of inproc) then the
entire dataset has to be serialized and moved over the wire. So try to use
DataTables instead, or move the data in chunks or something.

Signature

Klaus H. Probst, MVP
http://www.simulplex.net/

> Hi,
>
[quoted text clipped - 4 lines]
>
> Does anyone know what I can do to avoid this.

Reply to this Message

Arjuna Marambe - 20 Dec 2005 11:44 GMT

Returning a DataTable also does not help. Try the following SQL Statement
against the Northwind database and you will still get the same error.

"select top 400000 c1.* from customers c1, customers c2, customers c3"

Thanks
Arjuna.

> Don't pass so many records. Seriously, the dataset is a big memory hog
> because it's essentially an in-memory database. The problem here is that if
[quoted text clipped - 10 lines]
> >
> > Does anyone know what I can do to avoid this.

Reply to this Message

Serviced Component Throws OutOfMemoryException

Free Magazines