Bad customization work can also do this.. for e.g. if there is a search run during the save, that performs a table scan on a large table, you have a performance hit.. Its often you see such work from developers who have just begun working with systems that store data in a underlying RDBMS..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Patrick Zandi Sent: Monday, July 12, 2010 5:03 PM To: arslist@ARSLIST.ORG Subject: Re: Poor performance while saving Incidents ** My suggestion is too many indexes .... More indexes the slower the saving of the form. Test it Sent from my iPhone On Jul 12, 2010, at 4:14 PM, "Garrison, Sean (Norcross)" <sean.garri...@fiserv.com> wrote: ** Setting the field in the configuration file is not enough. You have to also run the stored procedure to update all of the tables to “In-Row” storage. Any new tables created by the arserver will use in-row storage. The lob storage conversion stored procedure is found in the “RemedyAndOracleCLOBs.pdf” document. Other things to check: 1. Do you have a lot of Indexes on HPD:HelpDesk? If so consider reducing any unnecessary indexes. The more indexes you add the slower the “INSERT INTO” sql statement … 2. Do you have any custom workflow that may be causing a delay? 3. Have you considered increasing the memory available to the DB? (By far the biggest performance improvement you will get) 4. Do you have Oracle Cursor sharing set to SIMILAR on both the Oracle DB and in the ar.conf file? Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of SriSamSri Appecherla Sent: Monday, July 12, 2010 4:00 PM To: arslist@ARSLIST.ORG Subject: Poor performance while saving Incidents ** Hi, Creating incidents is taking a lot of time. When I create an Incident, it is taking about 20-25 seconds to save, though I have set the Store LOB in row option from the server information window. I checked the SQL logs and found that a lot of time is wasted while setting the LOB fields. ARS 7.5, Patch 3 (in server group) Oracle 11g Sun Solaris 10 Please help. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
