As I recall, it allows mechanisms that use a large number of Request IDs in a short time (like an NMS) to only go to the DB once to grab the defined chunk of IDs and cache them for its own use, rather than constantly go ask for them one at a time.
Rick On 2/8/07, Jarl Grøneng <[EMAIL PROTECTED]> wrote:
Thanks, Do you mean several threads on the server, or several treads from the client? I has a import program doing this, but will rewrite it to support multiple threads. -- Jarl On 2/8/07, Ben Chernys <[EMAIL PROTECTED]> wrote: > This only has effect if you are running multiple threads. Further, the real use is to not place a lock on arschema so the effects will not be noticed until you have workflow creating multiple records firing simultaenously across multiple threads (possibly in different orders and timings). > > Example: > Thread 1 Thread 2 > cre XXX cre YYY > wait 1s cre XXX > cre YYY wait 1s > cre XXX cre XXX > > Cheers > Ben > > >----- ------- Original Message ------- ----- > >From: =?ISO-8859-1?Q?Jarl_Gr=F8neng?= > ><[EMAIL PROTECTED]> > >To: [email protected] > >Sent: Thu, 8 Feb 2007 12:33:03 > > > >Hi, > > > > > >Has anyone notice any incrase in performance > >setting > >Next-ID-Block-Size to a value higher than 2? > > > >Tried setting this up to 1000, but does not notice > >any increase in > >create operation. > > > >-- > >Jarl > > > >___________________________________________________ > >____________________________ > >UNSUBSCRIBE or access ARSlist Archives at > >www.arslist.org ARSlist:"Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
-- Rick Cook Cook Enterprises 253-278-4112 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

