Are these fields indexed? Joe
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Melissa Reed Sent: Thursday, April 26, 2007 11: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? No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.463 / Virus Database: 269.6.1/776 - Release Date: 4/25/2007 12:19 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
