How many records does the form hold and what do you have for indexes? Those are the first places I'd look.
Dylan -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Melissa Reed Sent: Thursday, April 26, 2007 8:54 AM To: [email protected] Subject: Performance problems with the HPD:HelpDesk_SLA form We are experiencing problems when users search on the HPD:HelpDesk_SLA form, either via the form or through the canned SLA performance reports. If you qualify on Arrival Time or Resolve Time, it can spike the Oralce CPU usage up to 25% or more (which is a huge amount for our environment). The query is taking 5-10 minutes to return, longer during peak times of the day. Has anyone else experienced this before? ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
