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"
