Kathey Marsden wrote:
Sunitha Kambhampati (JIRA) wrote:
using setString instead of setCharacterStream in this case ( insert of 500kb
clob) performs way much better. But ofcourse, setString cannot be used for
large data (or data that wont fit into memory) and one would need to use
streams.
Is there a similar performance impact with getCharacterStream vs
getString() or is it generally ok to use getCharacterStream()?
Thanks
Kathey
Hi Kathey,
I have not done a lot of analysis with getCharacterStream versus
getString so dont have much data to give you. . But for some simple
cases that I tried ( 500k) the difference in using getCharacterStream
versus getString was not so drastic as the case of the insert( ie
setString, setCharacterStream).
In general, you would use getCharacterStream when you are retrieving
large amounts of data otherwise getString is probably good.
Sunitha.