[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-20 Thread Tomohito Nakayama (JIRA)
[ 
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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-20 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12422405 ] 

Tomohito Nakayama commented on DERBY-1535:
--

The result of the test told that the errors happen when uploaded binary data 
was stored into the character type column such as CHAR(60), VARCHAR(60) , LONG 
VARCHAR .

These errors were considered as correct behavior in the test of Engine(and DB2 
driver) as shown in the next output of diff between master .out files.

[EMAIL 
PROTECTED]:~/derby/dev/trunk/java/testing/org/apache/derbyTesting/functionTests/master$
 diff parameterMapping.out DerbyNetClient/parameterMapping.out 
   
1823,1826c1354,1357
<   setBinaryStream() IC JDBC MATCH (INVALID)
<   setBinaryStream() as batch IC JDBC MATCH (INVALID)
<   setBinaryStream(null) IC JDBC MATCH (INVALID)
<   setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
>   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)
>   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)
>   setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
>   setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK)

1831,1838c1362,1369
<   setClob() IC JDBC MATCH (INVALID)
<   setClob() as batch IC JDBC MATCH (INVALID)
<   setClob(null) IC JDBC MATCH (INVALID)
<   setClob(null) as batch IC JDBC MATCH (INVALID)
<   setBlob() IC JDBC MATCH (INVALID)
<   setBlob() as batch IC JDBC MATCH (INVALID)
<   setBlob(null) IC JDBC MATCH (INVALID)
<   setBlob(null) as batch IC JDBC MATCH (INVALID)
---
>   setClob() getString=72  
>  was null false CLOUD EXT (OK)
>   setClob() as batch getString=72 
>   was null false CLOUD EXT (OK)
>   setClob(null) getString=null was null true CLOUD EXT (OK)
>   setClob(null) as batch getString=null was null true CLOUD EXT (OK)
>   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)
>   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)
>   setBlob(null) getString=null was null true CLOUD EXT (OK)
>   setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
  
2057,2060c1526,1529
<   setBinaryStream() IC JDBC MATCH (INVALID)
<   setBinaryStream() as batch IC JDBC MATCH (INVALID)
<   setBinaryStream(null) IC JDBC MATCH (INVALID)
<   setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
>   setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null 
> false CLOUD EXT (OK)
>   setBinaryStream() as batch getString=EncodedString: > 33347 51966 50 < was 
> null false CLOUD EXT (OK)
>   setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
>   setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK)
2065,2072c1534,1541
<   setClob() IC JDBC MATCH (INVALID)
<   setClob() as batch IC JDBC MATCH (INVALID)
<   setClob(null) IC JDBC MATCH (INVALID)
<   setClob(null) as batch IC JDBC MATCH (INVALID)
<   setBlob() IC JDBC MATCH (INVALID)
<   setBlob() as batch IC JDBC MATCH (INVALID)
<   setBlob(null) IC JDBC MATCH (INVALID)
<   setBlob(null) as batch IC JDBC MATCH (INVALID)
---
>   setClob() getString=72 was null false CLOUD EXT (OK)
>   setClob() as batch getString=72 was null false CLOUD EXT (OK)
>   setClob(null) getString=null was null true CLOUD EXT (OK)
>   setClob(null) as batch getString=null was null true CLOUD EXT (OK)
>   setBlob() getString=EncodedString: > 12867 29251 55 < was null false CLOUD 
> EXT (OK)
>   setBlob() as batch getString=EncodedString: > 12867 29251 55 < was null 
> false CLOUD EXT (OK)
>   setBlob(null) getString=null was null true CLOUD EXT (OK)
>   setBlob(null) as batch getString=null was null true CLOUD EXT (OK)
   
2291,2294c1698,1701
<   setBinaryStream() IC JDBC MATCH (INVALID)
<   setBinaryStream() as batch IC JDBC MATCH (INVALID)
<   setBinaryStream(null) IC JDBC MATCH (INVALID)
<   setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
>   se

[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-20 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12422411 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Correct expression in English 
<  I will make the behavior of the NetworkClient to that of the Engine in 
concerning part around this patch 
> I will make the behavior of the NetworkClient same to that of the Engine in 
> concerning parts around this patch 

> 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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-22 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12422821 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Committed ...
Sendingjava/drda/org/apache/derby/impl/drda/DDMReader.java
Sendingjava/drda/org/apache/derby/impl/drda/DRDAConnThread.java
Sending
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
Transmitting file data ...
Committed revision 424539.

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-24 Thread Sunitha Kambhampati (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423134 ] 

Sunitha Kambhampati commented on DERBY-1535:


Hi Tomohito, Thanks for looking into this issue.

I noticed, there are some differences in the master file for server and the 
embedded as you  mention in the earlier comment.  
-
[EMAIL 
PROTECTED]:~/derby/dev/trunk/java/testing/org/apache/derbyTesting/functionTests/master$
 diff parameterMapping.out DerbyNetClient/parameterMapping.out
   
1823,1826c1354,1357
< setBinaryStream() IC JDBC MATCH (INVALID)
< setBinaryStream() as batch IC JDBC MATCH (INVALID)
< setBinaryStream(null) IC JDBC MATCH (INVALID)
< setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
---
> 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)
> 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)
> setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
> setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK) 
---

Now with the recent patch to this issue, the first two lines in server are 
similar to the embedded.  But the output in case of setBinaryStream(null) is 
still different from the embedded case. as before.

Embedded has this
< setBinaryStream(null) IC JDBC MATCH (INVALID)
< setBinaryStream(null) as batch IC JDBC MATCH (INVALID) 

and Server has 
> setBinaryStream(null) getString=null was null true CLOUD EXT (OK)
> setBinaryStream(null) as batch getString=null was null true CLOUD EXT (OK) 

Do we also have some other existing issue here ?  Can you help me understand 
this difference in behavior.  Thanks. 

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-25 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423351 ] 

Tomohito Nakayama commented on DERBY-1535:
--

I overlooked the problem that setBinaryStream(null) is still different from 
embedded though setBinaryStream(notNullValue) is same.

This problem shouuld be resolved in this issue.

I think this problem happen because setBinaryStream of Engine is not called 
when setBinaryStream of Network Driver is called with null value. 

I start fix it.

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-25 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423367 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Surveying the source code, it seems to have something to do with difference 
between PreparedStatmement.setNull and 
PreparedStatement.setBinaryStream(null)

I'm not sure whether we can distinguish them in drda architecture.

Moreover, I came to have a question whether it is should be allowed to call 
setBinaryStream with null value.
Existence of setNull method may implicitly indicate set method should not 
be called with null value.
However, taking set method with null value as error would have much of 
impact to the existing applications ...

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-25 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423369 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Now, I just have read source code and there exists somethink not clear yet.
It seems to be needed to trace execution of program to know the fact more 
clearly.

I will continue to survey and report the result. 

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-25 Thread Andreas Korneliussen (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423375 ] 

Andreas Korneliussen commented on DERBY-1535:
-

I think there could be a problem here:

DRDAConnThread:
-   ps.setBytes(i+1, paramBytes);
+   ps.setBinaryStream(i+1, 
+   
   new ByteArrayInputStream(paramBytes),
+   

If paramBytes is null, it would previously be interpreted by the engine as 
there is a NULL value inserted into the database.
When creating a new ByteArrayInputStream, I guess it would be interpreted as 
inserting no data into the BLOB (if the paramBytes is null), or maybe a 
NullPointerException gets thrown


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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-25 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12423385 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Reading the code, the parameter of paramBytes seems not be null.
Instead, ps.setNull method seems to be called in 
DRDAConnThread.parseSQLDTA_work method.

However I can't conclude only by reading the source code.
Too much "seems to be" is in my report yet. *(
Current my recognition is that we need to trace execution of the program using 
jdb.

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-30 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12424361 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Continuing survey, I found the type compatibility problem around null value 
typed as InputStream seems to be not so tiny problem.

I created new task, DERBY-1610. 

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-08-21 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12429415 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Now, I'm preparing to rollback  DERBY-1513_1535_2.patch.
Please see more information in DERBY-1610.

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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-08-22 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12429734 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Patch for rollback committed.

Sendingjava/drda/org/apache/derby/impl/drda/DDMReader.java
Sendingjava/drda/org/apache/derby/impl/drda/DRDAConnThread.java
Sending
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
Transmitting file data ...
Committed revision 433655.

> 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-1513_1535_2.patch, 
> DERBY-1513_1535_rollback.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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-10-16 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12442589 ] 

Tomohito Nakayama commented on DERBY-1535:
--

I will resume this issue as improving room left in DERBY-1559.

http://issues.apache.org/jira/browse/DERBY-1559#action_12430023
http://issues.apache.org/jira/browse/DERBY-1559#action_12430034

> 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-1513_1535_2.patch, 
> DERBY-1513_1535_rollback.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




[jira] Commented: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-10-18 Thread Tomohito Nakayama (JIRA)
[ 
http://issues.apache.org/jira/browse/DERBY-1535?page=comments#action_12443270 ] 

Tomohito Nakayama commented on DERBY-1535:
--

Committed.

Sendingjava/drda/org/apache/derby/impl/drda/DRDAConnThread.java
Transmitting file data .
Committed revision 465249.


> 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-1513_1535_2.patch, 
> DERBY-1513_1535_rollback.patch, DERBY-1535.patch, DERBY-1535_2.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