Thanks Joe for the advice. It sounds like a good idea to add a unique index there.
BTW. I'm running ARS 7.0.1 // Niklas On 29/01/2008, Joe DeSouza <[EMAIL PROTECTED]> wrote: > > ** > Niklas, > > While I agree with the others that there should not be a performance > problem, I would strongly advise to modify the index of the Login Name field > to be a unique index. > > I have come across problems where there exists 2 or more records for the > same user in the user form due to the absense of workflow on the User form > to prevent duplicate Login Names. It happened to this customer during import > of a set of users directly to the user form.. > > You haven't specified what version of the ARS.. One of the earlier viersio > and the versions downward, didn't even have an index on the Login Name field > - leave alone a unique index.. Make sure you have one.. > > Cheers > > Joe D'Souza > Remedy Developer / Consultant, > IBM Global Technology Services, > Chicago. > > > ----- Original Message ---- > From: Carey Matthew Black <[EMAIL PROTECTED]> > To: [email protected] > Sent: Monday, January 28, 2008 7:06:29 AM > Subject: Re: Number of users in User form > > Niklas, > > The phrase "during ARS password changes and other such User form updates" > can be described as any data value in the User for was what I saw as "slower > then before". ('Email Address', 'Password', 'Default Notify Mechanism', > 'Group List', 'License Type', 'Full Text License Type', 'Login Name', > etc...) > > Again... I believe that was due to slowness of my RDBMS and not > necessarily due to ARS slowness. > > I however would also expect the RAM requirement for the ARS server and for > some secondary subsystems (like the Email Engine) to increase too. Those > components keep this data cached so they would be affected by such a growth > in the data. > > And if you are still using a per v7 Mid-Tier then I think it would also be > affected due to the way it caches objects based on 'Group List' combination > too. (However, I have not tested it for performance or RAM growth. But that > is my expectations.) > > -- > Carey Matthew Black > Remedy Skilled Professional (RSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > ------------------------------ > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it > now.<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ> > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
