Also I should note that if you do add indexes for the query you need to ensure that table statistics are updated for the Query Optimizer to recognize and utilize the new index tables.
Thanks Peter Lammey ESPN MIT Technical Services & Applications Management 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Wednesday, February 07, 2007 2:07 PM To: [email protected] Subject: Re: Remedy 6.3 Slow Searches ** Indexes could be either out of date (forcing a full) or your query is inefficient.. I would never show all tickets (15K) unless very specifically asked.. I would show users ticket within 30 days, and another tab showing every ticket with a warning.. but that is just a bad idea in the first place.. Just an Idea.. On 2/7/07, Tanner, Doug <[EMAIL PROTECTED]> wrote: ** Gene, Most of this issue is caused by the Requesters Cases (Table). You may wish to exclude that "User" Requester from the table field refresh. Or change it to something like the below Doug Tanner Senior Developer Remedy Skilled Professional (RSP) Former RAC (704) 328-3178 [EMAIL PROTECTED] ________________________________ From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Gene Ushinsky Sent: Wednesday, February 07, 2007 1:41 PM To: [email protected] Subject: Remedy 6.3 Slow Searches We use Remedy 6.3 and have close to 65,000 tickets in the database. These are spread over thousands of users with most users having 10-15 tickets. However, we use a generic user account to login tickets that don't belong to a particular user. This account has accumulated about 15,000 of the 65,000 tickets and it makes searching for tickets that involve that account go rather slowly. Instead of immediate response from the system while going down search results for a particular user, it stalls for 5-30 seconds when the search results are generated on that generic user. We are wondering what we can do to speed up these searches (if it is at all possible) short of archiving the tickets for that user or creating a new generic username. Any help would be appreciated. Gene gene ushinsky OIT - Service Desks Support Manager [EMAIL PROTECTED] | MB 161A | 801.422.2716 DISCLAIMER Important! This message is intended for the above named person(s) only and is CONFIDENTIAL AND PROPRIETARY. If you are not the intended recipient of this e-mail and have received it in error, please immediately notify the sender by return email and then delete it from your mailbox. This message may be protected by the attorney-client privilege and/or work product doctrine. Accessing, copying, disseminating or re-using any of the information contained in this e-mail by anyone other than the intended recipient is strictly prohibited. Finally, you should check this email and any attachments for the presence of viruses, as the sender accepts no liability for any damage caused by any virus transmitted by this email. Thank you. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<attachment: image001.jpg>>
