That's one of the issues we found, in dev cache mode it takes for ever because it doesn't build a new cache it updates the old one, so our server locks down for a minute or two while re-caching. In production mode it's not supposed to do that, it will build a new cache then once it's built switch people over to it, then eliminate the old cache.
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Coby West Sent: Thursday, July 12, 2007 4: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"