RE: PK Increment Step

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Fri Sep 02 2005 - 09:10:09 EDT

  • Next message: Neil Pierson: "Re: PK Increment Step"

    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:10:14 EDT