I'd also suggest to run the same SQL that is executed (capture it from the
SQL logs) directly against the DB and measure the response time. If there is
a significant difference in timing where the DB search is returned much
quicker, it would immediately tell you if it’s a problem at the DB level or
something within Remedy.. if within Remedy it could be factors like (or a
combination of factors like) number of records returned, whether or not
chunking is enabled on the AR side, etc. etc..
You could find out the same thing by taking a combined SQL and API log, and
analyzing that log..
Joe
-----Original Message-----
From: Longwing, LJ CTR MDA/IC
Sent: Wednesday, October 24, 2012 11:34 AM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: Sarch on HPD:Help Desk from taking a very long time.
And if you do a Show Plan, or, in whatever way is supported by your DB, what
does it say it's doing for those 25 seconds?
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Adarsh
Sent: Wednesday, October 24, 2012 9:30 AM
To: [email protected]
Subject: Re: Sarch on HPD:Help Desk from taking a very long time.
** I have following indexes on the HPD form
On Wed, Oct 24, 2012 at 8:45 PM, Adarsh <[email protected]> wrote:
Thanks Tauf,
I am trying to search all open tickets (status < "Resolved") assigned to a
particular group
'Status*' < "Resolved" AND 'Assigned Group*+' = "Service Desk"
On Wed, Oct 24, 2012 at 8:14 PM, Tauf Chowdhury <[email protected]> wrote:
** There are various factors such as how much data you are searching on,
indexing, etc...
What kind of searches are you doing? Are you searching for words in the
summary or Notes field?
What if you left everything blank and only select Status = "In Progress" ?
Does the data come back quicker? The status field is indexed by default (I
think) so just check that and report back. We would need more info to help
you though.
On Wed, Oct 24, 2012 at 10:40 AM, Adarsh <[email protected]> wrote:
** Hi ,
We are using Remedy 7.6.04 SP2 , currently we are facing a weird issue, The
application is working perfectly fine except for searches on HPD:Help Desk
form,
everything from database end has been checked, we did a re-org of the
tables and also rebuilt the indexes but still the issue is not resolved.
its takes around 25 seconds to refresh the data..
Has anyone faced such an issue.. ??? :-(
Regards,
Adarsh
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
--
Tauf Chowdhury
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
