I had the same problem, but with an asset management form with a couple of tables ...
I enabled the SQL logging for the client, did a refresh, and then copied the select statements from the log file to a SQL editor and ran the queries ... found two of the the select statements taking too long before coming back with data .... added chunking to the field table and also an index to one of the classes and it resolved my issue.... Add the followings before your selects if you don't want to execute your query and want to see how long it will take and if any indexes are being used etc ... set noexec on set showplan on set statistics time on ________________________________ De : John Kelley <[email protected]> À : [email protected] Envoyé le : Jeu 22 Octobre 2009, 14 h 20 min 35 s Objet : Re: AR System Email Messages Form ** I do have over 95,000 items in the email error logs form. Are you saying to delete those out and retry opening the email messages form. JK "Chowdhury, Tauf" <[email protected]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/22/2009 06:18 AM Please respond to [email protected] To [email protected] cc Subject Re: AR System Email Messages Form ** What I’ve seen as the usual suspect is the Email Error Logs form . Depending on what level of logging you have turned on for E-mail messages, that 1 e-mail entry may have 20 entries associated within the error log form. (I may be exaggerating) Tauf Chowdhury Analyst, Service Management Office: 631.858.7765 Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: Thursday, October 22, 2009 1:15 AM To: [email protected] Subject: Re: AR System Email Messages Form ** Its probably not the search of that form but the refresh of several table fields that are on that form. On Wed, Oct 21, 2009 at 11:10 PM, John Kelley <[email protected]> wrote: Hi List Has anyone had issues loading the AR System Email Messages in search mode? It takes way to long to load. I deleted all but one entry in the messages form and if I refresh my search results, it takes over a minute to load the one entry. It is so slow. Any Suggestions? ARS 7.1 patch 6 Oracle 10G ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
