Hi Murtuza, Thanks for the response. But those indexes that you have mentioned were for the T-Table behind the HelPDesk form. THese indexes will improve the response time when we open the form using the AR User Tool. but i am facing problems when i access the Active LInks of HelpDesk using the AR Admin tool.
Please provide me if there is any other alternate solutions. Thanks in Advance. Regards, Vinod On 4/19/07, msb ***** <[EMAIL PROTECTED]> wrote:
Hello Vinod, If you double-click the Helpdesk form, you will see a tab called Indexes in the Form properties window. There should be some indexes pre-listed there on the right hand side. You can add more indexes here if your users search on specific fields. You will also have to check in the database if the pre-listed indexes actually exist. There is a KB article on how to do this. -Murtuza. >From: Vinod Kumar <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: Performance Issue with Active Links- Reg., >Date: Thu, 19 Apr 2007 08:46:38 +0530 > >Hi, >I tried to understand more about OOTB index on the HelpDesk form but i >couldnt progress in it. > >Can anyone please help me to understand what a OOTB Index is , and how i >can check if it has got corrupted? If so, how do i correct the corrupted >indexes. > >THanks in Advance. > >Regards, >Vinod > > > > >----- Original Message ---- >From: Murtuza Bookwala <[EMAIL PROTECTED]> >To: [email protected] >Sent: Saturday, 14 April, 2007 1:58:34 PM >Subject: Re: Performance Issue with Active Links- Reg., > >Hello Vinod, > >Last time I had this problem, I found that the OOTB Indexes on the Helpdesk >form had become corrupt. >You can check that in the database. > >Regards, >Murtuza. > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Rabi Tripathi >Sent: Thursday, April 12, 2007 7:56 AM >To: [email protected] >Subject: Re: Performance Issue with Active Links- Reg., > >Vinod: >It makes sense that Helpdesk form's objects open relatively slower than >smaller forms'. > >The question is whether 100 seconds is reasobable for your setup or not. No >way to judge that without details of what you mean by... > >...from a "remote" machine > >What do you mean by "remote"? What's the link between the client and the >server? Dialup, LAN, WAN? VPN? > >You essentially need to think of the link between your client and the >server >as a pipe with numerous links in series and figure out whether it's >choking...your client PC, your local network, remote network, server >(hardware, software setup, database)? > >Use basic elimination techniques to rule out what is >*not* a problem and look at the remaining suspects more closely. For >example, if access through Remedy User from the same client PC is rather >fast, the network is likely not an issue. If access using Remedy admin on >the server itself is fast, then server side stuff including database is not >an issue. Also, is it slow for others in your local network..for others in >some other network? You get the idea. Another important question is whether >it suddenly become slow or it has always been like this. > >If you want listers to point out the suspect, you will need to post details >of you client PC, the network, the server hardware, the database details, >concurrent user load etc. > >The last time I saw unusually slow opening of objects was when somebody had >hacked into the underlying database to change the last modified date of all >the objects and set them to some future date by mistake. >Very unusual issue, **most likely irrelevant to you**. > >Sorry, I can't tell you exactly what the issue is in your environment. >There >is no substitute to following basic troubleshooting steps. > >Regards. > >--- Vinod <[EMAIL PROTECTED]> wrote: > >>Hi, >>We currently work on one of the customised HelpDesk application. >>Whenever i open any active link of the HelpDesk form from a remote >>machine, it takes around 90-100 seconds whereas when i open an >>activelink of any other form in the same environment, it takes around >>15 seconds. >> >>Taking 15 seconds for opening an object from a remote machine is >>acceptable but 100 seconds is too high. I am trying to find out the >>reason for the issue and i am looking for ways to improve the >>performance, whenever i open the active links of our HelpDesk form. >> >>Please provide me with some insight/thoughts on what may be the reason >>for such performance issue? Any suggestions or ideas for rectifying >>the issue is highly appretiated. >> >>Server : ARSystem 6.3 >>Admin Tool : 6.3 (Patch 20) >> >>THanks and Regards, >>Vinod >> > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >the Answers Are" _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ _______________________________________________________________________________ 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"
