db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1331473 - in /db/derby/docs/trunk/src: ref/crefproper22250.dita ref/refderby.ditamap ref/rrefproperstatementcachesize.dita tuning/ctundepth32379.dita
Date Fri, 27 Apr 2012 15:39:59 GMT
Author: chaase3
Date: Fri Apr 27 15:39:59 2012
New Revision: 1331473

URL: http://svn.apache.org/viewvc?rev=1331473&view=rev
Log:
DERBY-4280  Property not documented - derby.language.statementCacheSize

Added new Reference Manual topic and modified another; modified a Tuning Derby topic.

Patch: DERBY-4280-2.diff

Added:
    db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/crefproper22250.dita
    db/derby/docs/trunk/src/ref/refderby.ditamap
    db/derby/docs/trunk/src/tuning/ctundepth32379.dita

Modified: db/derby/docs/trunk/src/ref/crefproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/crefproper22250.dita?rev=1331473&r1=1331472&r2=1331473&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/crefproper22250.dita (original)
+++ db/derby/docs/trunk/src/ref/crefproper22250.dita Fri Apr 27 15:39:59 2012
@@ -219,6 +219,11 @@ about when changes to the property are d
 <entry colname="3">Static</entry>
 </row>
 <row>
+<entry colname="1"><i><xref href="rrefproperstatementcachesize.dita#rrefproperstatementcachesizer">derby.language.statementCacheSize</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">Static</entry>
+</row>
+<row>
 <entry colname="1"><i><xref href="rrefproper10607.dita#rrefproper10607">derby.locks.deadlockTimeout</xref></i></entry>
 <entry colname="2">S, D</entry>
 <entry colname="3">Dynamic</entry>

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=1331473&r1=1331472&r2=1331473&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Fri Apr 27 15:39:59 2012
@@ -854,6 +854,8 @@ URL syntax"></topicref>
 <topicref href="rrefproper43517.dita" navtitle="derby.language.logStatementText">
 </topicref>
 <topicref href="rrefproperpreallocator.dita" navtitle="derby.language.sequence.preallocator"></topicref>
+<topicref href="rrefproperstatementcachesize.dita" navtitle="derby.language.statementCacheSize">
+</topicref>
 <topicref href="rrefproper10607.dita" navtitle="derby.locks.deadlockTimeout">
 </topicref>
 <topicref href="rrefproper23835.dita" navtitle="derby.locks.deadlockTrace">

Added: db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita?rev=1331473&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita Fri Apr 27 15:39:59 2012
@@ -0,0 +1,55 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rrefproperstatementcachesize" xml:lang="en-us">
+<title>derby.language.statementCacheSize</title>
+<prolog><metadata>
+<keywords>
+<indexterm>derby.language.statementCacheSize</indexterm>
+<indexterm>statement cache size<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section><title>Function</title>
+<p>Defines the size, in number of statements, of the database statement cache
+(prepared statements kept in memory).</p>
+<p>This property controls the number of precompiled statements which
+<ph conref="../conrefs.dita#prod/productshortname"></ph> keeps in its statement
+cache. Consider raising this number if statement preparation is taking too much
+time.</p>
+<p>For more information on the statement cache, see "Using the statement cache"
+in <ph conref="../conrefs.dita#pub/cittuning"></ph>.</p>
+<p>Set this property to zero if you find that deadlocks are occurring when
+prepared statements become outdated. These deadlocks can happen in
+multi-threaded applications that alternate selects and updates.</p>
+</section>
+<section><title>Default</title>
+<p>100 statements.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.language.statementCacheSize=200</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+does not take effect until you reboot.</p>
+</section>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproperstatementcachesize.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/tuning/ctundepth32379.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctundepth32379.dita?rev=1331473&r1=1331472&r2=1331473&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/ctundepth32379.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctundepth32379.dita Fri Apr 27 15:39:59 2012
@@ -80,5 +80,16 @@ however.</p>
 cache</title>
 <image href="stmt_os.gif" placement="break"><alt>This figure shows how Derby
can reuse a statement execution plan that is already in the statement cache, even when the
statement is executed from a different connection. The figure shows three executions of two
similar statements over two different database connections. Each database connection has its
own statement cache. One statement is "SELECT * FROM mytable WHERE id = ?". The other statement
is "SELECT * FROM mytable WHERE id = 2". The statement that uses the dynamic parameter is
executed on both Connection One and Connection Two. When it is executed the second time, on
Connection Two, it can use the statement execution plan that is already in the statement cache
of Connection One. The version that does not use a dynamic parameter is executed on Connection
Two only and uses the statement cache for Connection Two.</alt></image>
 </fig>
+<p>The <i>derby.language.statementCacheSize</i> property controls the number
of
+precompiled statements which
+<ph conref="../conrefs.dita#prod/productshortname"></ph> keeps in its statement
+cache. Consider raising this number if statement preparation is taking too much
+time. See the <ph conref="../conrefs.dita#pub/citref"></ph> for more information
+on this property.</p>
+<p>A multithreaded database application that frequently alternates select and
+update statements can encounter deadlocks when a prepared statement becomes
+invalid or outdated. If your application becomes deadlocked under these
+circumstances, you can work around this problem by setting the value of the
+<i>derby.language.statementCacheSize</i> property to zero.</p>
 </conbody>
 </concept>



Mime
View raw message