Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Garbage collection not happening?
On 3 Sep 2002 at 14:36, Jacy Grannis so generously added:
> B/c there's some in memory processing that has to take place on the
> records after they've been read out of the db and before they are
> written out. Also note that this is taking place on a webserver and
> writing out to a file would require the user to take another step to
> get their results (clicking on a link to download the file). We may
> actually end up having to do that anyway, but it would be nice if the
> user could submit the form and get the download without a second
> click. Finally, while writing out to file could work, there is no
> reason that having 6MB of data in memory should cause an
> OutOfMemoryError, particularly as the same process works fine if it is
> not running on iPlanet but as a standalone app.
Your user would not have to click an extra link, nor would you have to write this file to disk and have them then use that. You can just have your servlet change the content type to something like 'text/plain' and then write your output (csv file) directly to the OutputStream you get from your http response object.
-- Jason Simpson "No, I'm not going to explain it. If you can't figure it out, you didn't want to know anyway... :-)" -- Larry WallReceived on Tue Sep 03 2002 - 17:47:25 CDT