Issue Details (XML | Word | Printable)

Key: DERBY-2281
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Laura Stewart
Reporter: Laura Stewart
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

Update the Tuning Guide figure about using the statement cache

Created: 31/Jan/07 07:34 PM   Updated: 01/Mar/07 05:51 PM
Return to search
Component/s: Documentation
Affects Version/s: 10.2.3.0
Fix Version/s: 10.3.1.4

Time Tracking:
Not Specified

File Attachments:
  Size
File Licensed for inclusion in ASF works derby2281.diff 2007-03-01 12:05 AM Laura Stewart 171 kB
File Licensed for inclusion in ASF works derby2281_2.diff 2007-03-01 12:19 AM Laura Stewart 233 kB
Image Attachments:

1. itserv_os.gif
(8 kB)

2. itserv_os.jpg
(29 kB)

3. stmt_os.gif
(11 kB)

4. stmt_os.jpg
(55 kB)

Resolution Date: 01/Mar/07 12:29 AM


 Description  « Hide
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.


 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Laura Stewart added a comment - 27/Feb/07 10:22 PM
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.

Laura Stewart added a comment - 27/Feb/07 10:30 PM
Oops, attached the file wrong files. The CORRECT files are stmt_os

Stan Bradbury added a comment - 28/Feb/07 11:22 PM
These new graphics are good. The problems I identified in my review of Derby-1842 have been fixed.

Laura Stewart added a comment - 01/Mar/07 12:05 AM
Patch that includes updated graphic itserv_os that is in the Tuning Guide topic cdevdeploy855368.dita

Laura Stewart added a comment - 01/Mar/07 12:19 AM
Attaching an updated patch. This patch updates the graphic stmt_os in the file ctundepth32379.

Laura Stewart added a comment - 01/Mar/07 12:29 AM
Committed revision 513078.