You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Laura Stewart (JIRA)" <ji...@apache.org> on 2007/01/31 20:36:05 UTC

[jira] Created: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Update the Tuning Guide figure about using the statement cache
--------------------------------------------------------------

                 Key: DERBY-2281
                 URL: https://issues.apache.org/jira/browse/DERBY-2281
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 10.2.3.0
            Reporter: Laura Stewart
         Assigned To: Laura Stewart
            Priority: Minor


The second figure in file ctundepth32379.dita needs to be updated. 

These comments came from Stan Bradbury as part of his review for Derby-1842

Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Stan Bradbury (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12476761 ] 

Stan Bradbury commented on DERBY-2281:
--------------------------------------

These new graphics are good.  The problems I identified in my review of Derby-1842 have been fixed.

> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-2281:
---------------------------------

    Attachment: derby2281_2.diff

Attaching an updated patch. This patch updates the graphic stmt_os in the file ctundepth32379.

> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby2281.diff, derby2281_2.diff, itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-2281:
---------------------------------

    Attachment: itserv_os.jpg
                itserv_os.gif

Attaching updated graphic files in both gif and jpg formats.
I think that there should be some additional spacing vertically to 
separate the 3 SELECT statements and associated objects and cache.

Please review and let me know of any changes that need to be made.
After I receive all of the comments, I'll post html files and a patch file.

> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: itserv_os.gif, itserv_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-2281:
---------------------------------

    Attachment: derby2281.diff

Patch that includes updated graphic itserv_os that is in the Tuning Guide topic cdevdeploy855368.dita

> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: derby2281.diff, itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Resolved: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart resolved DERBY-2281.
----------------------------------

       Resolution: Fixed
    Fix Version/s: 10.3.0.0

Committed revision 513078.

> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: derby2281.diff, derby2281_2.diff, itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart closed DERBY-2281.
--------------------------------


> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>             Fix For: 10.3.0.0
>
>         Attachments: derby2281.diff, derby2281_2.diff, itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (DERBY-2281) Update the Tuning Guide figure about using the statement cache

Posted by "Laura Stewart (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-2281?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Laura Stewart updated DERBY-2281:
---------------------------------

    Attachment: stmt_os.jpg
                stmt_os.gif

Oops, attached the file wrong files. The CORRECT files are stmt_os


> Update the Tuning Guide figure about using the statement cache
> --------------------------------------------------------------
>
>                 Key: DERBY-2281
>                 URL: https://issues.apache.org/jira/browse/DERBY-2281
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.2.3.0
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>            Priority: Minor
>         Attachments: itserv_os.gif, itserv_os.jpg, stmt_os.gif, stmt_os.jpg
>
>
> The second figure in file ctundepth32379.dita needs to be updated. 
> These comments came from Stan Bradbury as part of his review for Derby-1842
> Fig 2 : The graphic is not correct - I suggest a horizontal line separating Connection One and Connection Two (line should run under the TOP select, it's three exection-arrows and the TOP Statement Object) - label: 'Connection One' should be ABOVE the Select statement and FIRST execution-arrow for the Connection (not below an execution-arrow). 
> Label 'Connection Two' should be above the SECOND select (below the added line) and it's FIRST execution-arrow (the second solid arrow). This arrow needs to be the only arrow pointing to the SECOND Statement Object. 
> Replace the dotted line at the bottom with a STRAIGTH, SOLID line that runs STRAIGHT between the BOTTOM select statement and the BOTTOM (third) Statement Object. There is no 'elbow' arrow for the second connection. 
> It is not clear that the only the TOP select AND the TOP Statement Object are part of Connection One. All three Connection One execution-arrows need to point to the SAME (TOP) Statement Object. The next TWO selects, exectuion-arrows and Statement Objects need to be in do not line up properly . --The arrows between the Statment Objects and the Statement Cache pages are good. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.