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) ?
Subject
Written By
Posted
When will setFetchSize() work properly ?
November 21, 2004 11:59PM
November 22, 2004 11:09AM
November 22, 2004 04:53PM
November 22, 2004 07:23PM
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.