Martin Cordova wrote : > > I checked sequence definitions via SQLStudio, "Cached values" is > disabled, without information. > > SEQUENCE_CACHE = 1 according to DBM. > > Is there anything else to check? > > I created the sequence like: create sequence seq_xxx start with 1 > Did it assume a default cache of 20 or something? > > Regards, > Martin > > > On 7/4/06, Robert Klemme <[EMAIL PROTECTED]> wrote: > > 2006/7/4, Martin Cordova <[EMAIL PROTECTED]>: > > > Hello: > > > > > > I have a sequence that jumps 19 values when used the > first time after > > > a database restart. > > > > > > Normally it works fine, until a Db restart, then jumps 19 values. > > > > This might be due to caching of sequence values. > > > > Kind regards > > > > robert > > >
According to the documentation 20 values are cached by default : CACHE | NOCACHE If neither CACHE nor NOCACHE is specified, CACHE 20 is assumed. * CACHE: Access to the sequence can be accelerated because the defined number of sequence values is already held in the memory. * NOCACHE: There are no predefined sequence values. If you don't want any caching, please specify NOCACHE in the create sequence statement : create sequence seq_xxx start with 1 nocache Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
