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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2011/06/30 13:12:28 UTC

[jira] [Commented] (DERBY-5307) Document the behavior of the derby.language.sequence.preallocator property.

    [ 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