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)" <[email protected]> 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:[email protected]] On Behalf Of SriSamSri Appecherla > Sent: Monday, July 12, 2010 4:00 PM > To: [email protected] > 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 > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
