Re: Sarch on HPD:Help Desk from taking a very long time.

[Longwing, LJ CTR MDA/IC]

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:arslist@ARSLIST.ORG] On Behalf Of Adarsh
Sent: Wednesday, October 24, 2012 9:30 AM
To: arslist@ARSLIST.ORG
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 <adarsh.padwal...@gmail.com> 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 <taufc...@gmail.com> 
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 
<adarsh.padwal...@gmail.com> 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"