Re: [QUESTIONS] JDBC ResultSet size limit?

[thread moved to interfaces list]

On Thu, 16 Apr 1998, Mike Engelhart wrote:

> Is there a maximum size of a ResultSet, i.e approximately how many rows can
> a ResultSet in an applet hold?

It's limited by amount of memory available to the applet or application.

Like libpq, it retrieves the entire result in one go, so if the result is
large, then you have to wait while the result is retrieved.

Because of this, and if you are expecting a large amount of data to be
retrieved, then you'd be advised to use cursors.

Also, if you get out of memory errors, this doesn't mean that you have run
out of memory. In Java, the VM has a default setting for the amount of
memory to use. There are command line options to increase this. However,
I'm not sure how you can do this for applets (if at all possible).

--
Peter T Mount petermount(at)earthling(dot)net or pmount(at)maidast(dot)demon(dot)co(dot)uk
Main Homepage: http://www.demon.co.uk/finder
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter(at)maidstone(dot)gov(dot)(dot)uk