When will setFetchSize() work properly ?
Posted by: R Lenard
Date: November 21, 2004 11:59PM

According to the javadoc/source (with 3.0.16) it appears that the driver only support

1 row at a time (streamed) or all rows in a go.

Now 1 row at a time is *REALLY* poor for performance with large data sets (but allows you to ensure you will always have sufficient memory to hit the data), but all rows in a go requires the a-priori knowledge of how many rows will be pulled over to ensure there is sufficient memory on the client to hold the results (which is a bit chicken before the egg).

When will setFetchSize() allow setting of values, so that setFetchSize(100) limits the number fetched to 100 at a time, but still allows all the data to be retreived (i.e. in chunks of 100) ?

Options: ReplyQuote

Written By
When will setFetchSize() work properly ?
November 21, 2004 11:59PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.