db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-5307) Document the behavior of the derby.language.sequence.preallocator property.
Date Thu, 30 Jun 2011 11:12:28 GMT

    [ 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

        

Mime
View raw message