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 "Kim Haase (JIRA)" <ji...@apache.org> on 2007/12/06 19:57:01 UTC
[jira] Created: (DERBY-3259) Tuning manual needs performance tip on
compressing tables
Tuning manual needs performance tip on compressing tables
---------------------------------------------------------
Key: DERBY-3259
URL: https://issues.apache.org/jira/browse/DERBY-3259
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.3.1.4
Reporter: Kim Haase
The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3259) Tuning manual needs performance tip on
compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-3259:
-----------------------------------
Attachment: docs.diff
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunstats849505.html, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798368#action_12798368 ]
Bryan Pendleton commented on DERBY-3259:
----------------------------------------
The email thread mentioned in the description contains lots of good information that
I can edit into the new doc topic.
It seems like we also need a few notes regarding SYSCS_UPDATE_STATISTICS, and
possibly also note that, negatively, SYSCS_INPLACE_COMPRESS_TABLE does *not*
update the statistics. See DERBY-4289, DERBY-4121, and DERBY-1964 for related thoughts.
I'll take a stab at creating a new "Ensure statistics are accurate" topic for the Performance Tips
section of the Tuning guide, and post the results when I've got something ready to read.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton reassigned DERBY-3259:
--------------------------------------
Assignee: Bryan Pendleton
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Dag H. Wanvik (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799735#action_12799735 ]
Dag H. Wanvik commented on DERBY-3259:
--------------------------------------
Thanks for making these improvements, Bryan. +1
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunperfstatistics.html, ctunstats849505.html, ctunstats849505.html, docs.diff, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3259) Tuning manual needs performance tip on
compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-3259:
-----------------------------------
Attachment: docs.diff
ctunstats849505.html
ctunperfstatistics.html
Hi Kim, thanks for the review and good suggestions. I think I've incorporated
them into the latest attached patch proposal, and have also attached the
updated HTML versions of the "Ensure statistics are accurate" and
"When statistics go stale" topics.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunperfstatistics.html, ctunstats849505.html, ctunstats849505.html, docs.diff, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798791#action_12798791 ]
Kim Haase commented on DERBY-3259:
----------------------------------
Thanks very much for picking this up, Bryan. The new topic is very clear and well-written. I have only a few minor non-technical suggestions.
In the new text in "When cardinality statistics go stale", I'd suggest changing "info" to "information" where it occurs, to be consistent. Also, at the end of the second new paragraph, "procedures" should be changed to "procedure", since you're advising them to run one or the other procedure, not both.
In the new topic, you might want to add an indexterm or two, just in case we are ever able to generate an index. Also, it seems polite for links to other topics to include the title of the topic in the link, just so that users know where exactly they are going. It's a matter of taste, though.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunstats849505.html, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton resolved DERBY-3259.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
Thanks Kim and Dag for the timely reviews. Committed to the documentation trunk as revision 898944.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Fix For: 10.6.0.0
>
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunperfstatistics.html, ctunstats849505.html, ctunstats849505.html, docs.diff, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3259) Tuning manual needs performance tip on
compressing tables
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-3259:
-----------------------------------
Attachment: ctunstats849505.html
ctunperf25864.html
ctunperfstatistics.html
Attached is a proposed docs patch, and HTML formatted versions of
the 3 modified files: "The Tips", "Ensure table statistics are accurate",
and "When cardinality statistics go stale".
I think that the information elsewhere in the tuning and ref guides is
pretty complete; I think this new 'tips' page basically serves to alert
users to this potential situation and to direct their attention to the
relevant documentation.
Please let me know what you think of the changes.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunstats849505.html, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3259) Tuning manual needs performance tip
on compressing tables
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12799768#action_12799768 ]
Kim Haase commented on DERBY-3259:
----------------------------------
Thanks a lot, Bryan! +1 from the doc end too.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunperfstatistics.html, ctunstats849505.html, ctunstats849505.html, docs.diff, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-3259) Tuning manual needs performance tip on
compressing tables
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3259?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-3259.
----------------------------
Fixes appear in Latest Alpha Manuals, so closing.
> Tuning manual needs performance tip on compressing tables
> ---------------------------------------------------------
>
> Key: DERBY-3259
> URL: https://issues.apache.org/jira/browse/DERBY-3259
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.1.4
> Reporter: Kim Haase
> Assignee: Bryan Pendleton
> Fix For: 10.6.0.0
>
> Attachments: ctunperf25864.html, ctunperfstatistics.html, ctunperfstatistics.html, ctunstats849505.html, ctunstats849505.html, docs.diff, docs.diff
>
>
> The "Performance Tips and Tricks" section of the Tuning Derby manual needs a topic that recommends the use of the SYSCS_UTIL.SYSCS_COMPRESS_TABLE procedure to resolve performance problems having to do with indexes and complex table joins. (Please rephrase this if I haven't put it correctly.)
> For details, see the discussion at http://www.nabble.com/Re%3A-FW%3A-Advice-on-*very*-badly-performing-query-tf4939807.html.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.