Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2281

Update the Tuning Guide figure about using the statement cache

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.2.1
    • 10.3.1.4
    • Documentation
    • None

    Description

      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.

      Attachments

        1. itserv_os.gif
          8 kB
          Laura Stewart
        2. itserv_os.jpg
          29 kB
          Laura Stewart
        3. stmt_os.gif
          11 kB
          Laura Stewart
        4. stmt_os.jpg
          55 kB
          Laura Stewart
        5. derby2281.diff
          171 kB
          Laura Stewart
        6. derby2281_2.diff
          233 kB
          Laura Stewart

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            scotsmatrix Laura Stewart
            scotsmatrix Laura Stewart
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment