I am getting some memory errors when I attempt to pull back approx 150,000 or more rows into my collection using subsonic. Currently I am getting an out of memory error when this occurs. Upon further review and debugging I am noticing that the following line seems to be the culprit of the error:
OrdersCollection orders = new OrdersCollection();
orders.Load(Orders.FetchByParameter(Orders.Columns.OrderID, order.OrderID));
I am wondering if FetchByParameter is the correct method I need to be using or if I need to possibly change that to the SubSonic.Query approach. I have not been able to find any articles or posting with this issue so any help in the matter will be appreciated.