Thanks,
Andrew Baxter
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Axton
Sent: Monday, September 08, 2008 4:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Latency on Search
**
Run the query against the db and get the db statistics from the two
servers. Use sqlplus and type 'set autotrace on', then run the query,
this will give the execution plan and statistics. Post the plan and
stats from each server.
Axton Grams
On Mon, Sep 8, 2008 at 4:14 PM, Joe DeSouza <[EMAIL PROTECTED]>
wrote:
**
What are the different statuses you have on that form? Can you please
enlist them in the order they appear?
Joe
----- Original Message ----
From: Chintan Shah <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Monday, September 8, 2008 3:49:42 PM
Subject: Re: Latency on Search
**
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
**
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
****This e-mail is sent by Hudson Highland Group, Inc., or one of its
subsidiaries, and may contain information that is privileged or confidential.
If you are not the intended recipient, please delete the e-mail and any
attachments and notify us immediately.****
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
