There are 2 table fields that are getting refreshed and both of them run on the
same form(current form itself).
1. Query From 1st table field property,
( 'A' = $A$) AND ( 'B' != $B$)
A is indexed and B is 'trouble ID' which is by default indexed.
2. The second table field that gets refreshed has following qualification
( 'A' = $A$) AND (NOT (( 'Status' = "Resolved") OR ( 'Status' = "Closed")))
The same query runs extremely fast on production server, however it runs slow
on reporting server. Only difference is the number of records on both
servers(reporting holds some 150,000 records more).
Thanks
Chintan.
--- On Mon, 9/8/08, Joe DeSouza <[EMAIL PROTECTED]> wrote:
From: Joe DeSouza <[EMAIL PROTECTED]>
Subject: Re: Latency on Search
To: arslist@ARSLIST.ORG
Date: Monday, September 8, 2008, 12:21 PM
**
Could you send the qualification that you see out here to the list?
Joe
----- Original Message ----
From: Chintan Shah <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, September 8, 2008 3:11:06 PM
Subject: Re: Latency on Search
**
Hi Joe,
Thanks for replying. I indexed the fields and issue still persists.
I think it might be because of no. of records it needs to look at.
Thanks
Chintan.
--- On Mon, 9/8/08, Joe DeSouza <[EMAIL PROTECTED]> wrote:
From: Joe DeSouza <[EMAIL PROTECTED]>
Subject: Re: Latency on Search
To: arslist@ARSLIST.ORG
Date: Monday, September 8, 2008, 10:19 AM
**
Chintan,
Check the qualification on the table field and the form against which this
table field is getting its data from. Make sure that the qualification on the
table field is optimized - meaning that it does make use of indexes on the form
that its getting its data from.. Create indexes if necessary for columns that
appear in the qualificaiton if they do not have an index on them on the form
its getting its data from..
Joe
----- Original Message ----
From: Chintan Shah <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, September 8, 2008 1:06:11 PM
Subject: Latency on Search
**
Hi all,
We are seeing some weird latency issue on couple of forms.
We archived forms and originally they were all archived forms. We detached it
from original forms so that they become regular forms. Queries were running
extremely fast when they were detached, however just today we found out that
when you run a query through "User" tool on those detached regular forms , it
finds record but sits on "Refreshing table up to Administrator's limit" for a
LONG time before finally showing record in results list.
I am not sure at this point if something changed on DB side, but I would like
to know if there is something from Remedy Side that I can investigate.
ARServer 6.03 patch 22.
Oracle 10.2.0.2.0
Solaris 5.10
Any help greatly appreciated.
Thanks
Chintan
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
