db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-815) Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()
Date Wed, 01 Feb 2006 17:43:05 GMT
    [ http://issues.apache.org/jira/browse/DERBY-815?page=comments#action_12364831 ] 

A B commented on DERBY-815:
---------------------------

Good catch.  Actually, I think the error in embedded mode is probably correct, given the repro
I posted.  When we insert the 3rd row, we do two setBlobs and two setClobs; for the fourth
row, we do a setNull for one of the blobs and for one of the clobs (params 7 and 9) but do
not re-set the others (params 6 and 8), and hence this error occurs because we're trying to
re-use the lob streams.  If you add the following two lines to the block for the 4th row:

    pSt.setBlob(6, rs.getBlob(6));
    pSt.setClob(8, rs.getClob(8));

then the test case will pass with embedded and still show the regression hang against the
client.  As for why the client didn't throw an error, I think it's because materialization
of the lobs occurs on the client/server, so we're not reusing a "stream" per se, we're just
reusing the materialized versions of the lobs.  I believe this is related to DERBY-326 and
DERBY-550... (thanks to Sunitha for the pointers!).

> Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()
> -----------------------------------------------------------------------------
>
>          Key: DERBY-815
>          URL: http://issues.apache.org/jira/browse/DERBY-815
>      Project: Derby
>         Type: Sub-task
>   Components: Network Server, Performance
>     Versions: 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.1.3.0, 10.1.2.2, 10.0.2.2
>     Reporter: Knut Anders Hatlen
>     Priority: Minor
>      Fix For: 10.2.0.0
>  Attachments: d815_regress.diff, d815_regress.java, d815_regress.stat, d815_regress_derbyall_report.txt,
derby-815.diff, derby-815.stat, derby.log, derbyall_report.txt
>
> Reported by Kathey Marsden in DERBY-212:
> In reviewing the Network Server Code and profiling there were several
> areas that showed potential for providing performance
> improvement. Functions that need optimizing to prevent unneeded object
> creation and excessive decoding: parseSQLDTA_work()

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message