Re: PK Increment Step

From: Eric Schneider (eri..entralparksoftware.com)
Date: Fri Sep 02 2005 - 09:35:34 EDT

  • Next message: Andrus Adamchik: "Re: Status of handling of generated columns w/1.2M5 & SQL server"

    If you happen to be using Oracle, there is another way to set this in
    the modeler.

    In the DB entity pane, there's a pk generation section where you can
    configure this.

    Cheers,
    e.

    On Sep 2, 2005, at 9:10 AM, Gentry, Michael ((Contractor)) wrote:

    > I believe the 20 you are referencing is how many PKs will be cached by
    > default (and this can be changed at run-time). So if your PK table
    > has
    > a value of 1000 for a given table and new PKs are requested, it'll
    > bump
    > it up to 1020 and then not request PKs for 20 more inserts into that
    > table. So, when doing multiple inserts, the cache saves trips to
    > the DB
    > which can speed things up.
    >
    > -----Original Message-----
    > From: noba..andex.ru [mailto:noban@yandex.ru]
    > Sent: Friday, September 02, 2005 6:46 AM
    > To: cayenne-use..bjectstyle.org
    > Subject: PK Increment Step
    >
    >
    >
    > Hi!
    >
    > Is it possible to change PK AUTO INCREMENT step from 20 to other.
    > I`ve looked for answer in XML conf files, but didn`t found anything as
    > well as in API docs.
    >
    > One more question why Increment Step is set to 20? And what will
    > happen when PK will reach its maximum capacity?
    >
    >
    >
    >



    This archive was generated by hypermail 2.0.0 : Fri Sep 02 2005 - 09:35:35 EDT