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.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"