You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Ole Solberg (JIRA)" <ji...@apache.org> on 2008/11/04 09:58:44 UTC

[jira] Commented: (DERBY-3825) StoreStreamClob.getReader(charPos) performs poorly

    [ https://issues.apache.org/jira/browse/DERBY-3825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12644928#action_12644928 ] 

Ole Solberg commented on DERBY-3825:
------------------------------------

10.4 Tinderbox build 
http://dbtg.thresher.com/derby/test/tinderbox_10.4_16/UpdateInfo/710076-buildDetails.txt
reports:


pptesting:

compile:
    [mkdir] Created dir: Apache/TinderBox-10.4/10.4/classes.pptesting
    [javac] Compiling 11 source files to Apache/TinderBox-10.4/10.4/classes.pptesting
    [javac] Apache/TinderBox-10.4/10.4/java/testing/org/apache/derby/impl/jdbc/UTF8ReaderTest.java:57: cannot find symbol
    [javac] symbol  : method setAutoCommit(boolean)
    [javac] location: class org.apache.derby.impl.jdbc.UTF8ReaderTest
    [javac]         setAutoCommit(false);
    [javac]         ^
    [javac] Apache/TinderBox-10.4/10.4/java/testing/org/apache/derby/impl/jdbc/UTF8ReaderTest.java:88: cannot find symbol
    [javac] symbol  : method setAutoCommit(boolean)
    [javac] location: class org.apache.derby.impl.jdbc.UTF8ReaderTest
    [javac]         setAutoCommit(false);
    [javac]         ^
    [javac] Apache/TinderBox-10.4/10.4/java/testing/org/apache/derby/impl/jdbc/UTF8ReaderTest.java:126: cannot find symbol
    [javac] symbol  : method setAutoCommit(boolean)
    [javac] location: class org.apache.derby.impl.jdbc.UTF8ReaderTest
    [javac]         setAutoCommit(false);
    [javac]         ^
    [javac] Note: Apache/TinderBox-10.4/10.4/java/testing/org/apache/derby/impl/drda/TestProto.java uses unchecked or unsafe operations.
    [javac] Note: Recompile with -Xlint:unchecked for details.
    [javac] 3 errors

BUILD FAILED
Apache/TinderBox-10.4/10.4/build.xml:457: The following error occurred while executing this line:
Apache/TinderBox-10.4/10.4/java/testing/org/apache/derby/build.xml:44: Compile failed; see the compiler error output for details.


Dittot on 10.4 branch build last night: 

> StoreStreamClob.getReader(charPos) performs poorly
> --------------------------------------------------
>
>                 Key: DERBY-3825
>                 URL: https://issues.apache.org/jira/browse/DERBY-3825
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC, Store
>    Affects Versions: 10.5.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kristian Waagan
>             Fix For: 10.4.2.1, 10.5.0.0
>
>         Attachments: derby-3825-0a-preview.diff, derby-3825-1a-reset_readpositioninbuffer.diff, derby-3825-2a-internalReader_repositioning.diff, derby-3825-2a-internalReader_repositioning.stat, derby-3825-2b-internalReader_repositioning.diff, derby-3825-3a-simplification.diff
>
>
> StoreStreamClob.getReader(charPos) performs poorly because it resets the underlying stream and skips data until it reached the requested character position. Not only does the data has to be skipped, it also has to be decoded (UTF-8).
> The problem is exposed through EmbedClob.getSubString, which causes extremely bad performance for the client driver because the locator based Clob implementation uses this method.
> For the record, there is another read buffer size issue that exaggerates the problem (it will probably be handled under DERBY-3769, and also DERBY-3818).

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