Also the time logged between the SQL statement and the OK is the time taken for the database to perform the query - the time taken to return the results to the server and perform any subsequent workflow processing is the gap between the OK and the next bit of SQL. As Misi says filter logging may help you see what is happening, if not, it could be that there are a large number of records being returned.
Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: 03 April 2014 07:16 To: arslist@ARSLIST.ORG Subject: Re: Execution Time between API and SQL Logging Hi, If you turn on FLTR-logging it will probably be more clear where the time disappears. Archiving does not seem to be the obvious solution unless you are doing a lot of FLTR-table-loops. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Hi Ars Team, > > I have run the arlogtimer utility, and observed that the Execution > times in API is above 4 seconds for all the transactions. > > However, the execution times in SQL is maximum 1 second. > > I think it indicates that there is no need to perform indexes, but > there is a need to check the workflow and maybe archive data. > > Please do share your thoughts. > > Thank you, > Regards, > Sonia > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"