db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-1012) Network Server should release prepared statements as they are closed on the client instead of waiting until the section is reused
Date Sun, 19 Feb 2006 17:57:05 GMT
Network Server should release prepared statements as they are closed on the client instead
of waiting until the section is reused
---------------------------------------------------------------------------------------------------------------------------------

         Key: DERBY-1012
         URL: http://issues.apache.org/jira/browse/DERBY-1012
     Project: Derby
        Type: Improvement
  Components: Network Server  
    Versions: 10.2.0.0    
    Reporter: Kathey Marsden
    Priority: Minor


Because DRDA has no CLSSTMT command the client cannot notify the server when a  prepared statement
is closed.  Currently  the server finds out that a statement has been closed when the client
 sends a prepare with the same package and section number.  The server then closes the statement
and prepares the new one.  This means for example if 20000 statements are valid and open and
then all closed, 20000 prepared statements will stay open on the server until the connection
is closed.

I tend to think that DRDA will have to be enhanced to make this improvement, but maybe someone
has some other ideas.


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