db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r208690 [3/3] - /incubator/derby/docs/trunk/src/tuning/
Date Thu, 30 Jun 2005 22:34:59 GMT
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform866547.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform866547.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform866547.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform866547.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  

Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform866587.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform866587.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform866587.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform866587.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  

Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform867602.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform867602.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform867602.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform867602.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  

Modified: incubator/derby/docs/trunk/src/tuning/ttundepth33391.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ttundepth33391.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ttundepth33391.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ttundepth33391.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,8 @@
 <?xml version="1.0" encoding="utf-8"?>
+<!DOCTYPE task PUBLIC "-//IBM//DTD DITA Task//EN"
+ "../dtd/task.dtd">
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  
@@ -14,9 +16,6 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE task PUBLIC "-//IBM//DTD DITA Task//EN"
- "../dtd/task.dtd">
 <task id="ttundepth33391" xml:lang="en-us">
 <title>Analyzing statement execution</title>
 <prolog><metadata>
@@ -26,10 +25,10 @@
 <indexterm>Checkpoint</indexterm></keywords>
 </metadata></prolog>
 <taskbody>
-<context> After you create indexes, make sure that <ph conref="tunconrefs.dita#prod/productshortname"></ph>
is using them. In
-addition, you might also want to find out the join order <ph conref="tunconrefs.dita#prod/productshortname"></ph>
is choosing
-and force a better order if necessary.<p>A general plan of attack for analyzing
-your application's SQL statements:</p></context>
+<context> After you create indexes, make sure that <ph conref="tunconrefs.dita#prod/productshortname"></ph>
is
+using them. In addition, you might also want to find out the join order <ph
+conref="tunconrefs.dita#prod/productshortname"></ph> is choosing.<p>A general
+plan of attack for analyzing your application's SQL statements:</p></context>
 <steps>
 <step><cmd>Collect your application's most frequently used SQL statements
 and transactions into a single test.</cmd></step>
@@ -43,15 +42,18 @@
 <step><cmd>Use performance timings to identify poorly performing queries.
 Try to distinguish between cached and uncached data. Focus on measuring operations
 on uncached data (data not already in memory). For example, the first time
-you run a query, <ph conref="tunconrefs.dita#prod/productshortname"></ph> returns
uncached data. If you run the same query immediately
-afterward, <ph conref="tunconrefs.dita#prod/productshortname"></ph> is probably
returning cached data. The performance of these
-two otherwise identical statements varies significantly and skews results.</cmd>
-</step>
+you run a query, <ph conref="tunconrefs.dita#prod/productshortname"></ph> returns
+uncached data. If you run the same query immediately afterward, <ph conref="tunconrefs.dita#prod/productshortname"></ph>
is
+probably returning cached data. The performance of these two otherwise identical
+statements varies significantly and skews results.</cmd></step>
 <step><cmd>Use RunTimeStatistics to identify tables that are scanned excessively.
 Check that the appropriate indexes are being used to satisfy the query and
-that <ph conref="tunconrefs.dita#prod/productshortname"></ph> is choosing the
best join order. Force a better order when necessary.
-See <xref href="ctundepth13055.dita#ctundepth13055"></xref> for more information.</cmd>
-</step>
+that <ph conref="tunconrefs.dita#prod/productshortname"></ph> is choosing
+the best join order.  You can also set derby.language.logQueryPlan to true
+to check whether indexes are being used or not. This property will  is print
+query plans in the derby.log file. See <xref href="rtunproper43414.dita#rtunproper43414"></xref>,
+as well as <xref href="ctundepth13055.dita#ctundepth13055"></xref> for more
+information.</cmd></step>
 <step><cmd>Make any necessary changes and then repeat.</cmd></step>
 <step><cmd>If changing data access does not create significant improvements,
 consider other database design changes, such as denormalizing data to reduce
@@ -60,4 +62,3 @@
 </steps>
 </taskbody>
 </task>
-

Modified: incubator/derby/docs/trunk/src/tuning/ttundepth34375.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/ttundepth34375.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/ttundepth34375.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/ttundepth34375.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  

Modified: incubator/derby/docs/trunk/src/tuning/tunconrefs.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/tunconrefs.dita?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/tunconrefs.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/tunconrefs.dita Thu Jun 30 15:34:50 2005
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="utf-8"?>
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  
@@ -35,7 +35,7 @@
 <concept id="vers" xml:lang="en-us">
 <title>Version and release numbers</title>
 <conbody>
-<p><ph id="fullversionnumber">Open Source</ph></p>
+<p><ph id="fullversionnumber">Version 10.1</ph></p>
 </conbody>
 </concept>
 <concept id="pub" xml:lang="en-us">

Modified: incubator/derby/docs/trunk/src/tuning/tuningderby.ditamap
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/tuningderby.ditamap?rev=208690&r1=208689&r2=208690&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/tuningderby.ditamap (original)
+++ incubator/derby/docs/trunk/src/tuning/tuningderby.ditamap Thu Jun 30 15:34:50 2005
@@ -2,7 +2,7 @@
 <!DOCTYPE map PUBLIC "-//IBM//DTD DITA Map//EN"
  "../dtd/map.dtd">
 <!-- 
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.  
+Copyright 1997, 2005 The Apache Software Foundation or its licensors, as applicable.  
 
 Licensed under the Apache License, Version 2.0 (the "License");  
 you may not use this file except in compliance with the License.  
@@ -19,7 +19,7 @@
 <map title="Tuning Derby">
 <topicmeta>
 <copyright>
-<copyryear year="1997, 2004"/>
+<copyryear year="1997, 2005"/>
 <copyrholder>Apache Software Foundation</copyrholder>
 </copyright>
 <prodinfo>
@@ -102,7 +102,7 @@
 <topicref collection-type="family" href="ctundepth39739.dita" navtitle="Tuning databases
and applications">
 <topicref collection-type="family" href="ctundepth21935.dita" navtitle="Application and
database design issues">
 <topicref collection-type="family" href="ctundepth10525.dita" navtitle="Avoiding table
scans of large tables">
-<topicref collection-type="family" href="ctundepth23033.dita" navtitle="Index, index,
index">
+<topicref collection-type="family" href="ctundepth23033.dita" navtitle="Always create
indexes">
 <topicref href="ctundepth1002853.dita" navtitle="Create useful indexes" toc="no">
 </topicref>
 <topicref href="ctundepth1003116.dita" navtitle="Make sure indexes are being used, and
rebuild them"



Mime
View raw message