if your set doesn't fit into memory, saving it to a temp file won't get you out of troubles. One of DAL problems is that a Rows object does not return an iterator from the cursor, it's fetched all into memory first.
On Wednesday, November 7, 2012 12:45:46 PM UTC+1, Johann Spies wrote: > > On 7 November 2012 13:32, Niphlod <nip...@gmail.com <javascript:>> wrote: > >> far too magic to check for something that basically isn't trustable: even >> if you code something like that and you check that there's x mb available, >> another user can ask for another huge set of data and your "previoulsy" >> free RAM is not free anymore. >> >> > True. What about writing it to a temporary file and stream it from > there. What would the effect on resources be? > > Regards > Johann > -- > Because experiencing your loyal love is better than life itself, > my lips will praise you. (Psalm 63:3) > > --