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 "Rick Hillegas (JIRA)" <ji...@apache.org> on 2011/06/29 18:11:29 UTC
[jira] [Created] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Document the behavior of the derby.language.sequence.preallocator property.
---------------------------------------------------------------------------
Key: DERBY-5307
URL: https://issues.apache.org/jira/browse/DERBY-5307
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.8.1.5, 10.9.0.0
Reporter: Rick Hillegas
The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
o Add a section on this property parallel to the sections for other properties in the Reference Guide.
o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5307:
---------------------------------
Issue & fix info: [Patch Available]
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127608#comment-13127608 ]
Rick Hillegas commented on DERBY-5307:
--------------------------------------
And just to make the situation more confusing, the property is still supported for sequences. It just doesn't affect identity columns in the 10.8 branch. People who use 10.8.2 can still adjust the behavior of sequences by turning this knob...but they won't know about the knob unless they follow the conversation on the Derby lists.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.2.0, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.2.0, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5307:
---------------------------------
Attachment: derby-5307-01-ab-newProperty.tar
derby-5307-01-ab-newProperty.diff
Thanks for the quick review, Knut. I have incorporated your suggestions in a second rev of the patch: derby-5307-01-ab-newProperty.diff and derby-5307-01-ab-newProperty.tar.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas updated DERBY-5307:
---------------------------------
Attachment: derby-5307-01-aa-newProperty.tar
derby-5307-01-aa-newProperty.diff
Attaching derby-5307-01-aa-newProperty.diff. This patch documents the new derby.language.sequence.preallocator property and points the CREATE TABLE and CREATE SEQUENCE documentation at it. Also attaching a tarball of generated html output: derby-5307-01-aa-newProperty.tar.
Touches the following files:
--------
M src/ref/refderby.ditamap
M src/ref/crefproper22250.dita
A src/ref/rrefproperpreallocator.dita
New topic for the new property.
--------
M src/ref/rrefsqlj37836.dita
M src/ref/rrefsqljcreatesequence.dita
Points the "generated-column-spec" and "CREATE SEQUENCE" topics at the new property.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas reassigned DERBY-5307:
------------------------------------
Assignee: Rick Hillegas
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Closed] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas closed DERBY-5307.
--------------------------------
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.1.5, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057969#comment-13057969 ]
Rick Hillegas commented on DERBY-5307:
--------------------------------------
Ported 1141568 from trunk docs to 10.8 docs at subversion revision 1141651.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rick Hillegas resolved DERBY-5307.
----------------------------------
Resolution: Fixed
Fix Version/s: 10.9.0.0
10.8.1.5
Issue & fix info: (was: [Patch Available])
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.1.5, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127596#comment-13127596 ]
Kim Haase commented on DERBY-5307:
----------------------------------
Note: these documentation changes were backed out in one of the DERBY-5448 patches, because the property has been removed from Derby 10.8.2.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.2.0, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.2.0, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Kim Haase (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13127602#comment-13127602 ]
Kim Haase commented on DERBY-5307:
----------------------------------
The changes were backed out of the 10.8.2 branch, not the trunk.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.2.0, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.2.0, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057754#comment-13057754 ]
Knut Anders Hatlen commented on DERBY-5307:
-------------------------------------------
The patch looks good to me. Two small comments:
- The table in the "Derby properties" topic says that the property has scope "S, D", which I read as system-wide or database-wide. In the topic for the new property, it says the scope is system-wide only.
- Perhaps the "Concurrency" sections added to generated-column-spec and CREATE SEQUENCE statement should be called "Performance" instead, since preallocating a range also reduces the overhead significantly in the single-threaded case. And maybe: "Derby preallocates ranges of upcoming values for sequences and identity columns in order to reduce the overhead of generating the values, and thereby boost the performance and concurrency of these operations. The length of these ranges can be ..." ?
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13250016#comment-13250016 ]
Rick Hillegas commented on DERBY-5307:
--------------------------------------
These changes were further adjusted by the work on DERBY-5687. The documentation no longer talks about identity columns.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.2.2, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Fix For: 10.8.2.2, 10.9.0.0
>
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (DERBY-5307) Document the behavior of the
derby.language.sequence.preallocator property.
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5307?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13057880#comment-13057880 ]
Rick Hillegas commented on DERBY-5307:
--------------------------------------
Committed derby-5307-01-ab-newProperty.diff at subversion revision 1141568.
> Document the behavior of the derby.language.sequence.preallocator property.
> ---------------------------------------------------------------------------
>
> Key: DERBY-5307
> URL: https://issues.apache.org/jira/browse/DERBY-5307
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.8.1.5, 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5307-01-aa-newProperty.diff, derby-5307-01-aa-newProperty.tar, derby-5307-01-ab-newProperty.diff, derby-5307-01-ab-newProperty.tar
>
>
> The work on DERBY-4437 introduced a new property: derby.language.sequence.preallocator. The user documentation should describe this property. I think the following should be sufficient:
> o Add a section on this property parallel to the sections for other properties in the Reference Guide.
> o Point the CREATE TABLE and CREATE SEQUENCE topics to the new section.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira