db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: [jira] Commented: (DERBY-302) Takes over 3 minutes to insert a 500kb String into CLOB
Date Tue, 24 May 2005 23:46:32 GMT
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.

Mime
View raw message