Re: PK Increment Step

From: noban (noba..andex.ru)
Date: Fri Sep 02 2005 - 10:00:11 EDT

  • Next message: Øyvind Harboe: "Detailed log/progress view?"

      Thanks a lot for Info!

    >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?
    >>
    >>
    >>
    >>
    >

    -- 
    ñÎÄÅËÓ.ðÏÞÔÁ: ÏÂßÅÍ ÐÏÞÔÏ×ÏÇÏ ÑÝÉËÁ ÎÅ ÏÇÒÁÎÉÞÅÎ! http://mail.yandex.ru/monitoring/
    



    This archive was generated by hypermail 2.0.0 : Fri Sep 02 2005 - 10:00:29 EDT