db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomohito Nakayama (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage
Date Thu, 20 Jul 2006 11:28:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12422397 ] 
            
Tomohito Nakayama commented on DERBY-1535:
------------------------------------------

I found  DERBY-1513_1535.patch causes error in parameterMapping.java as next.
   derbyall/derbynetclientmats/derbynetmats.fail:jdbcapi/parameterMapping.java

Reading the results, this error seem to have something to do with 
conversion between streamed-binary and stored-text.

Next are what was found in parameterMapping.diff .

setXXX() with all JDBC Types on CHAR(60)
For setXXX() methods that pass an object, a null and valid values are checked
--------------------
1354 del
<   setBinaryStream() getString=EncodedString: > 33347 51966 50 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT
(OK)
1355 del
<   setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD
EXT (OK)
1355a1354,1355
>   setBinaryStream() IC JDBC MATCH (INVALID)
>   setBinaryStream() as batch IC JDBC MATCH (INVALID)
1366 del
<   setBlob() getString=EncodedString: > 12867 29251 55 32 32 32 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
1367 del
<   setBlob() as batch getString=EncodedString: > 12867 29251 55 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32
32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT
(OK)
1367a1366,1367
>   setBlob() IC JDBC MATCH (INVALID)
>   setBlob() as batch IC JDBC MATCH (INVALID)


setXXX() with all JDBC Types on VARCHAR(60)
For setXXX() methods that pass an object, a null and valid values are checked
--------------------
1526 del
<   setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false
CLOUD EXT (OK)
1527 del
<   setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 < was null
false CLOUD EXT (OK)
1527a1526,1527
>   setBinaryStream() IC JDBC MATCH (INVALID)
>   setBinaryStream() as batch IC JDBC MATCH (INVALID)
1538 del
<   setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD EXT
(OK)
1539 del
<   setBlob() as batch getString=EncodedString: > 12867 29251 55 < was null false
CLOUD EXT (OK)
1539a1538,1539
>   setBlob() IC JDBC MATCH (INVALID)
>   setBlob() as batch IC JDBC MATCH (INVALID)


setXXX() with all JDBC Types on LONG VARCHAR
For setXXX() methods that pass an object, a null and valid values are checked
--------------------
1698 del
<   setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false
CLOUD EXT (OK)
1699 del
<   setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 < was null
false CLOUD EXT (OK)
1699a1698,1699
>   setBinaryStream() IC JDBC MATCH (INVALID)
>   setBinaryStream() as batch IC JDBC MATCH (INVALID)
1710 del
<   setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD EXT
(OK)
1711 del
<   setBlob() as batch getString=EncodedString: > 12867 29251 55 < was null false
CLOUD EXT (OK)
1711a1710,1711
>   setBlob() IC JDBC MATCH (INVALID)
>   setBlob() as batch IC JDBC MATCH (INVALID)


> Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage
> ---------------------------------------------------------------------------------------
>
>                 Key: DERBY-1535
>                 URL: http://issues.apache.org/jira/browse/DERBY-1535
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Network Server
>            Reporter: Tomohito Nakayama
>         Assigned To: Tomohito Nakayama
>         Attachments: DERBY-1513_1535.patch, DERBY-1535.patch, serverMemoryUsage.xls,
serverMemoryUsage_1513_1535.xls
>
>
> Through DERBY-1513, Trial 1 for DERBY-550, 
> it was suggested that NetworkServer seems to use Engine inefficiently and use too much
of memory.
> This task try to improve the use of Engine from NetworkServer and try to reduce memory
usage.

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