This is currently configured per entity. On the entity definition there is a sequence-bank-size attribute you can use to increase this to 100 or whatever.
BTW, which version of OFBiz are you using? Getting sequence IDs should be in a separate transaction from your main transaction, but of course even with a tiny transaction like that conflicts could occur. -David On Dec 12, 2009, at 11:26 AM, Brett Palmer wrote: > We are running a mysql 5.x database with 4 applications servers on the same > db. We use the GenericDelegator.getNextSeqId() a lot in our code and simple > methods. The default is for the sequencer to increment by 10 but under > heavy loads we are seeing the SequenceValueItem table get really hot with > updates that lock. > > We would like to avoid the frequency of locks on this table by increasing > the increment from 10 to 100 or bigger. > > Is this done in a configuration file? I see a method > GenericDelegator.getNextSeqId(seqName, staggerMax) that would probably work > but is this also available in a simple method. > > Thanks, > > > Brett
