What I think we have is some confusion in terms. While the nextId value for each form is stored in the arschema table for each form, there isn't any need (I would argue that it would be counterproductive) to have that value set at anything greater than zero FOR the arschema form itself. Since he reported issue wasn't with any form except arschema, and since the only time a nextId is requested for that form is when a new form is created, I fail to see the connection between your solution and the reported problem.
Now if you had suggested adding a db index to the arschema table, I could see the potential for performance improvements. Rick On Jun 8, 2011 12:13 PM, "Guillaume Rheault" <guilla...@dcshq.com> wrote: > Well, contention on the ARSCHEMA table affects all tables related to Remedy forms, since as you know the ARSCHEMA table stores the nextId for any Remedy form, and this table is updated and queried constantly. It therefore can frequently become a contention hot spot. > > Since the Remedy admin does not have control over the locking mechanisms on the table for insert, update or queries, then the only thing that can be done at the Remedy level is to set the Next Request ID Block Size. > > Guillaume > > ________________________________ > From: Action Request System discussion list(ARSList) [arslist@ARSLIST.ORG] on behalf of Rick Cook [remedyr...@gmail.com] > Sent: Wednesday, June 08, 2011 11:49 AM > To: arslist@ARSLIST.ORG > Subject: Re: Looooooooooong update times on ARSCHEMA > > ** > > How would that affect a form that isn't getting new inserts more than occasionally? The nextId setting only affects inserts. > > Rick > > On Jun 8, 2011 10:31 AM, "Guillaume Rheault" <guilla...@dcshq.com<mailto: guilla...@dcshq.com>> wrote: >> Hi Alkan, >> >> Have you set the Next Request ID Block Size to 10 or 20 (or even 100) ? This setting definitely alleviates the contention on the ARSCHEMA table. >> Definitely worth a try. >> >> Guillaume >> ________________________________________ >> From: Action Request System discussio_attend WWRUG11 www.wwrug.comARSlist: >> "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
