db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Suresh Thalamati (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2465) Clob data type should use getCharacterStream() to read a column data from a VTI instead of getString().
Date Mon, 19 Mar 2007 17:29:32 GMT
Clob data type should use getCharacterStream() to read a column  data from a VTI instead of
getString(). 
---------------------------------------------------------------------------------------------------------

                 Key: DERBY-2465
                 URL: https://issues.apache.org/jira/browse/DERBY-2465
             Project: Derby
          Issue Type: Improvement
    Affects Versions: 10.3.0.0
            Reporter: Suresh Thalamati


Currently clob data is read as String. This can consume lot of memory when lot 
of rows read from a VTI resultset. I think it would consume less memory if 
data is read using streams. 

org.apache.derby.iapi.types.SQLClob.java does not implement
setValueFromResultSet() that is used by the VTI to read the data, it defaults
to super class SQLChar.java implementation, which reads the data using 
getString(). 

One case I  noticed  the current implementation  uses lot of memory  is  when doing import
of clobs(DERBY-378). 


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message