Coby,
You need to ask you support agents to change activities status to "Deal with" in Activity form once they viewed customer activities. In Agent console, it only displays activities with "Need attention" status. If you have ton of open activities, it will take forever to loa. This happened to me before, after I got permission from our support center manager, I used modify all to changed the activity status to "Deal with" for all activities opened more than two month. And that solves the problem. Hui-Qing Bao Sr. System Analyst iDirect Technologies 13865 Sunrise Valley Drive Herndon, VA 20171 703-648-8104 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Coby West Sent: Thursday, July 12, 2007 5:05 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy CSS Slowness - too many Activities Thanks for the reply Randy. The Development Cache Mode flag is not checked. Is this what you mean? Coby -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Evans.Randy Sent: Thursday, July 12, 2007 1:23 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy CSS Slowness - too many Activities ** One thing to also look at are you running in production mode or dev mode? ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Coby West Sent: Thursday, July 12, 2007 2:48 PM To: arslist@ARSLIST.ORG Subject: Remedy CSS Slowness - too many Activities ** All, we are running Remedy CSS 5.6 with ARS 6.3 against an Oracle 10g backend. When changing groups using the Console View on the Agent Console, it is taking approx 1.5 to 2.0 minutes to return. I turn on logging and noticed it is taking a long time querying the T287 table. This is the table that holds the Activity/Interaction records. We have approx 1457236 records in this table. I also noticed in the SQL call it's doing an Order By. I think between the amount of records and the order by clause, this is the reason we're seeing so much slowness. I was just wondering if anyone has experience with this issue? Does anyone know where the order by clause is being generated from? Thanks for any help you can give me one this. Coby __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"