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
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.
