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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<<attachment: image001.jpg>>
