Mike,
I'd perform detailed logging to find out where exactly the time loss happen
(in remedy terms). Then I'd compare it to the server events and the tread
log to find out if the search co-incides with other server operation or it
is waiting for a free tread.
I know, it is not a lot of help, but if you are getting consistent search
results for different keys on the sql level the most common reason for
insonsistent search times - cached entries vs non-cached entries, is out of
the picture.
BTW, are you testing in production or in dev.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
----- Original Message -----
From: "versicle" <versi...@aol.com>
Newsgroups: public.remedy.arsystem.general
To: <arslist@ARSLIST.ORG>
Sent: Thursday, May 07, 2009 12:26 PM
Subject: Inconsistant Search times
All,
We've created a custom ticket form which as approximately 75 fields
including three tables. We've also imported approx 600K records to this
form. When we do a search on the unique index (field 1) we are getting
inconsistant response times. The search can take anywhere from less then
one
second to 8 seconds (this happens regardless if you use the same ID over
and
over or a different ID each time). The search only returns one row as
expected. We've run the query on the DB and via SQL plus from the app
server
and it returns within milliseconds. To add to this strange behaviour,
after
restarting the application servers, the response time is consistantly at
less then a second, then over about an 8 hour period is becomes
inconsistant. We've tried disabling escalations and adding indices as well
as adding some parameters to the ar.cfg (such as cluster-index, etc). All
other forms (HPD, CHG, etc) do not display this behaviour. As anyone seen
this before or have any ideas to try and get a consistant response?
We are running ARS 7.1 patch 5 and ITSM patch 8 on Windows 2003 and Oracle
10
Mike
--
View this message in context:
http://www.nabble.com/Inconsistant-Search-times-tp23430541p23430541.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
